public object GetMemberListSyncIOS(MemberSearch member) { dynamic MemberDirectorResult; try { string zipFilePath, FileName; MemberListSyncResult memberListSyncResult = MemberMaster.GetMemberListSyncIOS(member.updatedOn, member.grpID, out zipFilePath, out FileName); FileName = "Profile" + FileName + ".zip"; if (!string.IsNullOrEmpty(zipFilePath)) { MemberDirectorResult = new { status = "0", message = "success", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, FileName, memberListSyncResult }; } else if (memberListSyncResult.NewMemberList.Count == 0 && memberListSyncResult.UpdatedMemberList.Count == 0 && string.IsNullOrEmpty(memberListSyncResult.DeletedMemberList)) { MemberDirectorResult = new { status = "2", message = "No New Updates", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, FileName, memberListSyncResult }; } else { MemberDirectorResult = new { status = "0", message = "success", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, FileName, memberListSyncResult }; } } catch (Exception ex) { MemberDirectorResult = new { status = "1", error = ex.ToString(), message = "An error occured. Please contact Administrator", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") }; } return(MemberDirectorResult); }
public object UpdateProfileDetails(RootObject Input) { dynamic MemberDirectorResult; int result = MemberMaster.UpdateAllProfileDetails(Input); if (result > 0) { string profileID = Input.profileID; MemberMaster.AddMemberToDistrict(profileID, profileID); DateTime dt = DateTime.Now; if (Input.updatedOn != null) { dt = Convert.ToDateTime(Input.updatedOn); dt = dt.AddSeconds(-2); } // Forward to GetMemberListSync method to get updated records string zipFilePath = string.Empty; MemberListSyncResult MemberDetail = MemberMaster.GetMemberListSync(dt.ToString("yyyy/MM/dd HH:mm:ss"), Input.grpID, out zipFilePath); if (!string.IsNullOrEmpty(zipFilePath)) { MemberDirectorResult = new { status = "0", message = "success", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, MemberDetail }; } else if (MemberDetail.NewMemberList.Count == 0 && MemberDetail.UpdatedMemberList.Count == 0 && string.IsNullOrEmpty(MemberDetail.DeletedMemberList)) { MemberDirectorResult = new { status = "2", message = "No New Updates", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, MemberDetail }; } else { MemberDirectorResult = new { status = "0", message = "success", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, MemberDetail }; } } else { MemberDirectorResult = new { status = "1", message = "failed" }; } return(MemberDirectorResult); }
public object GetDistrictMemberListSync(MemberSearch member) { dynamic MemberDirectorResult; try { string zipFilePath = ""; DateTime currentDate = DateTime.Now; MemberListSyncResult MemberDetail = new MemberListSyncResult(); if (Convert.ToDateTime(member.updatedOn).Date.ToString("dd/MM/yyyy") == "01/01/1970") { zipFilePath = District.GetZipFilePath(member.updatedOn, member.grpID, out currentDate); } if (Convert.ToDateTime(member.updatedOn).Date.ToString("dd/MM/yyyy") != "01/01/1970" || string.IsNullOrEmpty(zipFilePath)) { MemberDetail = District.GetMemberListSync(member.updatedOn, member.grpID, out zipFilePath); } if (!string.IsNullOrEmpty(zipFilePath)) { MemberDirectorResult = new { status = "0", message = "success", curDate = currentDate.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, MemberDetail }; } else if (MemberDetail.NewMemberList.Count == 0 && MemberDetail.UpdatedMemberList.Count == 0 && string.IsNullOrEmpty(MemberDetail.DeletedMemberList)) { MemberDirectorResult = new { status = "2", message = "No New Updates", curDate = currentDate, zipFilePath, MemberDetail }; } else { MemberDirectorResult = new { status = "0", message = "success", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, MemberDetail }; } } catch (Exception ex) { MemberDirectorResult = new { status = "1", error = ex.ToString(), message = "An error occured. Please contact Administrator", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") }; } return(MemberDirectorResult); }
public object GetMemberListSync(MemberSearch member) { dynamic MemberDirectorResult; try { string zipFilePath; MemberListSyncResult MemberDetail = new MemberListSyncResult(); if (member.grpID == "31072" & Convert.ToDateTime(member.updatedOn).Date.ToString("dd/MM/yyyy") == "01/01/1970") { zipFilePath = "http://www.rosteronwheels.com/TempDocuments/DirectoryData/Profile10062017054630PM.zip"; } else { MemberDetail = MemberMaster.GetMemberListSync(member.updatedOn, member.grpID, out zipFilePath); } if (!string.IsNullOrEmpty(zipFilePath)) { MemberDirectorResult = new { status = "0", message = "success", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, MemberDetail }; } else if (MemberDetail.NewMemberList.Count == 0 && MemberDetail.UpdatedMemberList.Count == 0 && string.IsNullOrEmpty(MemberDetail.DeletedMemberList)) { MemberDirectorResult = new { status = "2", message = "No New Updates", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, MemberDetail }; } else { MemberDirectorResult = new { status = "0", message = "success", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), zipFilePath, MemberDetail }; } } catch (Exception ex) { MemberDirectorResult = new { status = "1", error = ex.ToString(), message = "An error occured. Please contact Administrator", curDate = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") }; } return(MemberDirectorResult); }
public static MemberListSyncResult GetMemberListSync(string updatedOn, string grpID, out string filepath) { bool isDataFound = false; string targetPath = ""; try { filepath = ""; MySqlParameter[] param = new MySqlParameter[2]; param[0] = new MySqlParameter("@groupID", grpID); param[1] = new MySqlParameter("@updatedOn", updatedOn); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V7_USPGetDirectoryListSync", param); DataTable dtnewMember = result.Tables[0]; DataTable dtUpdatedMember = result.Tables[1]; DataTable dtDeletedMember = result.Tables[2]; int dataCount = 10;// Used for paging. DataCount is page size List <MemberDetailsDynamicField> memberList; int Filecounter = 1; int totalrows = dtnewMember.Rows.Count; string FileName = "Dist-" + grpID + DateTime.Now.ToString("ddMMyyyyhhmmsstt"); MemberListSyncResult memListSyncResult = new MemberListSyncResult(); //======================= If total records less than 20 Return Json directly ================================================= int totalRowCount; if (Convert.ToDateTime(updatedOn).Date.ToString("dd/MM/yyyy") == "01/01/1970") { totalRowCount = dtnewMember.Rows.Count; } else { totalRowCount = dtnewMember.Rows.Count + dtUpdatedMember.Rows.Count; } if (totalRowCount <= 20) { //---------------Create array of new members ------------------------------- memberList = new List <MemberDetailsDynamicField>(); if (dtnewMember.Rows.Count > 0) { for (int i = 0; i < dtnewMember.Rows.Count; i++) { MemberDetailsDynamicField memberdtl = GetMemberDtlWithDynamicFeild(dtnewMember.Rows[i]["profileID"].ToString(), grpID); memberList.Add(memberdtl); } } memListSyncResult.NewMemberList = memberList; //---------------Create array of Updated members ------------------------------- memberList = new List <MemberDetailsDynamicField>(); if (dtUpdatedMember.Rows.Count > 0 && Convert.ToDateTime(updatedOn).Date.ToString("dd/MM/yyyy") != "01/01/1970") { for (int i = 0; i < dtUpdatedMember.Rows.Count; i++) { MemberDetailsDynamicField memberdtl = GetMemberDtlWithDynamicFeild(dtUpdatedMember.Rows[i]["profileID"].ToString(), grpID); memberList.Add(memberdtl); } } memListSyncResult.UpdatedMemberList = memberList; //-----------------Deleted member -------------------------------------------------- string deletedProfiles = ""; if (dtDeletedMember != null && Convert.ToDateTime(updatedOn).Date.ToString("dd/MM/yyyy") != "01/01/1970") { if (!string.IsNullOrEmpty(dtDeletedMember.Rows[0]["profileID"].ToString())) { deletedProfiles = dtDeletedMember.Rows[0]["profileID"].ToString(); } } memListSyncResult.DeletedMemberList = deletedProfiles; } //======================= If Records Greater than 20 Return Zip File ================================================= else { if (dtnewMember.Rows.Count > 0) { memberList = new List <MemberDetailsDynamicField>(); for (int i = 0; i < totalrows; i++) { if (i < dataCount) // add object to page { try { MemberDetailsDynamicField memberdtl = GetMemberDtlWithDynamicFeild(dtnewMember.Rows[i]["profileID"].ToString(), grpID); memberList.Add(memberdtl); MemberDetails memberDtl = new MemberDetails(); memberDtl.MemberDetail = memberList; // For each page create a seperate json file if (i == dataCount - 1 || i == totalrows - 1) { // create a file string json = JsonConvert.SerializeObject(memberDtl); //write string to file string Path = ConfigurationManager.AppSettings["imgPathSave"] + "TempDocuments\\DirectoryData\\Profile" + FileName; if (!Directory.Exists(Path)) { Directory.CreateDirectory(Path); } if (!Directory.Exists(Path + "/NewMembers")) { Directory.CreateDirectory(Path + "/NewMembers"); } System.IO.File.WriteAllText(Path + "/NewMembers/New" + Filecounter + ".json", json); Filecounter++; } } catch { } } else { // reset member list for next page memberList = new List <MemberDetailsDynamicField>(); dataCount = dataCount + 10; i--; } } } if (dtUpdatedMember.Rows.Count > 0 && Convert.ToDateTime(updatedOn).Date.ToString("dd/MM/yyyy") != "01/01/1970") { dataCount = 10; // Used for paging. dataCount is page size memberList = new List <MemberDetailsDynamicField>(); Filecounter = 1; totalrows = dtUpdatedMember.Rows.Count; for (int i = 0; i < totalrows; i++) { if (i < dataCount) { try { MemberDetailsDynamicField memberdtl = GetMemberDtlWithDynamicFeild(dtUpdatedMember.Rows[i]["profileID"].ToString(), grpID); memberList.Add(memberdtl); MemberDetails memberDtl = new MemberDetails(); memberDtl.MemberDetail = memberList; // For each page create a seperate json file if (i == dataCount - 1 || i == totalrows - 1) { // create a file string json = JsonConvert.SerializeObject(memberDtl); //write string to file string Path = ConfigurationManager.AppSettings["imgPathSave"] + "TempDocuments\\DirectoryData\\Profile" + FileName; if (!Directory.Exists(Path)) { Directory.CreateDirectory(Path); } if (!Directory.Exists(Path + "/UpdatedMembers")) { Directory.CreateDirectory(Path + "/UpdatedMembers"); } System.IO.File.WriteAllText(Path + "/UpdatedMembers/Update" + Filecounter + ".json", json); Filecounter++; } } catch { } } else { // reset member list for next page memberList = new List <MemberDetailsDynamicField>(); dataCount = dataCount + 10; i--; } } } if (dtDeletedMember != null && Convert.ToDateTime(updatedOn).Date.ToString("dd/MM/yyyy") != "01/01/1970") { if (!string.IsNullOrEmpty(dtDeletedMember.Rows[0]["profileID"].ToString())) { string deletedProfiles = dtDeletedMember.Rows[0]["profileID"].ToString(); string Path = ConfigurationManager.AppSettings["imgPathSave"] + "TempDocuments\\DirectoryData\\Profile" + FileName; if (!Directory.Exists(Path)) { Directory.CreateDirectory(Path); } if (!Directory.Exists(Path + "/DeletedMembers")) { Directory.CreateDirectory(Path + "/DeletedMembers"); } System.IO.File.WriteAllText(Path + "/DeletedMembers/Delete" + Filecounter + ".txt", deletedProfiles); } } string zipFolderPath = ConfigurationManager.AppSettings["imgPathSave"] + "TempDocuments\\DirectoryData\\Profile" + FileName; if (Directory.Exists(zipFolderPath)) { targetPath = ConfigurationManager.AppSettings["imgPathSave"] + "TempDocuments\\DirectoryData\\Profile" + FileName + ".zip"; zos = new ZipOutputStream(File.Create(targetPath)); zos.UseZip64 = UseZip64.Off; strBaseDir = zipFolderPath + "\\"; AddZipEntry(strBaseDir); zos.Finish(); zos.Close(); isDataFound = true; } if (isDataFound) { filepath = ConfigurationManager.AppSettings["imgPath"] + "TempDocuments/DirectoryData/Profile" + FileName + ".zip"; } } return(memListSyncResult); } catch { throw; } }