Upload Member Excel Sheet

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