Upload Member Excel Sheet

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

1 Point Save Data Flow

Bulk Member Upload

1. When we upload excel file if any error in excel then show alert message which excel column is wrong

2. If excel is improper as per format then upload in temp table

3. Create new list to disply uploaded data.

4. If wing and flat no same in other row then data is block and status is duplicate data

5. If FirstName, LastName typed in firstname block this data and data status is rejected and maintain the history of this excel sheet and this data will not save in main table.

6. If data is uploaded in main table and maintain the history for save successfully with excel file

...............................................................................................................................

Data Save in main table Flow

1. Wing column save in mstWing table . WingName is unique.

2. BHK column save in FlatType table . FlatTypeName is unique

3. FlatName column save in mstFlats table . FlatName is unique

4. SqFeet column save in mstFlats table . SqFeet is unique

5. FlatTypeID get from FlatType table and save in mstFlats column FlatType

6. WingId get from mstWingtable and save in mstFlats column WingId

7. Status column Get OccupiedId from mstOccupiedMaster and save in mstFlats column Tainentid

8. All information save in member table and Status Get OccupiedId from mstOccupiedMaster save in OccupiedId

2 Point Update Data Flow

1. From history list download the excel sheet which one uploaded in software .

2. Again we upload the excel sheet if flat no is same then update the data .

(only update flatName, SqFeet , BHK,Tainentid in mstflat table & all the information update in member table )

Otherwise flatname is not found in our mstflat table then save data same as structure

Note: If deadline is crossed then 500 Rs will be as a penalty

ASP.NET jQuery / Prototype JSON Servidor de Microsoft SQL MVC

Nº del proyecto: #17774052

Sobre el proyecto

6 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

vishalten

Have 6+ years of .Net Framework experience in Analysis, Designing, Development, Debugging and Maintenance of 3-tier Enterprise ASP.Net Developer,MVC Developer Has the ability to understand and transform complex bu Más

₹7777 INR en 3 días
(1 comentario)
4.8

6 freelancers están ofertando un promedio de ₹10129 por este trabajo

misraanu

Respected Sir/Madam, I am experienced ASP.NET developer with 8+ years of experience. I will like to pick up this job and deliver high quality and clean code in optimum time. Looking for positive response from your e Más

₹12222 INR en 10 días
(8 comentarios)
3.1
dotnetproject82

Hi, I am DotNet And Angular Developer With 12 years of Experience. I have already some excel upload related utilities available with me. My technologies stack is: - Frontend [ javascript, jquery,JSON,Ajax,CSS Más

₹12222 INR en 3 días
(4 comentarios)
1.9
demossoft

I have reviewed your bid request and I am very interested in your project. I was trained overseas and have an extensive customer service record so contact me so we can discuss further or begin. Relevant Skills and Exp Más

₹14444 INR en 10 días
(0 comentarios)
0.0