public object GetServiceDirectoryListSync(ServiceDirectorySearch serv)
{
dynamic TBServiceDirectoryResult;
List <object> ServiceDirectoryResult = new List <object>();
try
{
ServiceDirector Result = ServiceDirectory.GetServiceDirectoryListSync(serv);
TBServiceDirectoryResult = new { status = "0", message = "success", updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), Result };
}
catch
{
TBServiceDirectoryResult = new { status = "1", message = "An error occured. Please contact Administrator" };
}
return(new
{
TBServiceDirectoryResult
});
}
// For Offline data fetch
public static ServiceDirector GetServiceDirectoryListSync(ServiceDirectorySearch search)
{
try
{
MySqlParameter[] param = new MySqlParameter[3];
param[0] = new MySqlParameter("@grpId", search.groupId);
param[1] = new MySqlParameter("@moduleId", search.moduleId); // Added by Nandu on 30/09/2016 Task--> Module replica
param[2] = new MySqlParameter("@updateOn", search.updatedOn);
DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V6_USPGetServiceDirectoryListSync", param); // Added by Nandu on 30/09/2016 Task--> Module replica
DataTable dtNewServiceMember = result.Tables[0];
DataTable dtUpdatedServiceMember = result.Tables[1];
DataTable dtDeletedServiceMember = result.Tables[2];
List <ServiceDirectoryList> NewMemberList = new List <ServiceDirectoryList>();
if (dtNewServiceMember.Rows.Count > 0)
{
NewMemberList = GlobalFuns.DataTableToList <ServiceDirectoryList>(dtNewServiceMember);
foreach (ServiceDirectoryList sev in NewMemberList)
{
if (!string.IsNullOrEmpty(sev.image))
{
string ImageName = sev.image.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/servicedirectory/Group" + sev.groupId + "/thumb/";
sev.image = path + ImageName;
}
}
}
List <ServiceDirectoryList> updatedMemberList = new List <ServiceDirectoryList>();
if (dtUpdatedServiceMember.Rows.Count > 0)
{
updatedMemberList = GlobalFuns.DataTableToList <ServiceDirectoryList>(dtUpdatedServiceMember);
foreach (ServiceDirectoryList sev in updatedMemberList)
{
if (!string.IsNullOrEmpty(sev.image))
{
string ImageName = sev.image.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/servicedirectory/Group" + sev.groupId + "/thumb/";
sev.image = path + ImageName;
}
}
}
List <ServiceDirectoryList> deletedMemberList = new List <ServiceDirectoryList>();
if (dtDeletedServiceMember.Rows.Count > 0)
{
deletedMemberList = GlobalFuns.DataTableToList <ServiceDirectoryList>(dtDeletedServiceMember);
}
ServiceDirector serviceList = new ServiceDirector();
serviceList.deletedMembers = deletedMemberList;
serviceList.newMembers = NewMemberList;
serviceList.updatedMembers = updatedMemberList;
return(serviceList);
}
catch (Exception ex)
{
throw ex;
}
}
public object AddServiceDirectory(AddServiceDirectory addservice)
{
dynamic TBAddServiceResult;
int str = -1;
try
{
Imgname Result = ServiceDirectory.createService(addservice);
if (!string.IsNullOrEmpty(Result.imgName))
{
str = GlobalFuns.UploadImage(addservice.groupId, Result.imgName, "servicedirectory");
}
else
{
str = 0;
}
//if (Result != null)
//{
if (str == 0)
{
//TBAddServiceResult = new { status = "0", message = "success" };
ServiceDirectorySearch serv = new ServiceDirectorySearch();
serv.groupId = addservice.groupId;
serv.moduleId = addservice.moduleId;
DateTime dt = DateTime.Now;
if (addservice.updatedOn != null)
{
dt = Convert.ToDateTime(addservice.updatedOn);
dt = dt.AddSeconds(-1);
}
serv.updatedOn = dt.ToString("yyyy/MM/dd HH:mm:ss");
ServiceDirector res = ServiceDirectory.GetServiceDirectoryListSync(serv);
if (res != null)
{
TBAddServiceResult = new { status = "0", message = "success", updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), res };
}
else
{
TBAddServiceResult = new { status = "1", message = "failed", updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") };
}
}
else
{
TBAddServiceResult = new { status = "1", message = "failed" }
};
//}
//else
//{
// TBAddServiceResult = new { status = "0", message = "Record not found" };
//}
}
catch
{
TBAddServiceResult = new { status = "1", message = "failed" };
}
return(new { TBAddServiceResult });
}
