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;
}
}
