public object GetServiceDirectoryCategories(ServiceDirectorySearch service)
{
//dynamic TBServiceCategoriesResult;
List <object> ServiceCategoriesResult = new List <object>();
try
{
List <ServiceCategoryList> Result = ServiceDirectory.GetServiceDirCategoriesList(service);
for (int i = 0; i < Result.Count; i++)
{
ServiceCategoriesResult.Add(Result[i]);
}
if (ServiceCategoriesResult != null)
{
return(new { status = "0", message = "success", ServiceCategoriesResult });
}
else
{
return(new { status = "0", message = "Record not found" });
}
}
catch
{
return(new { status = "1", message = "failed" });
}
}
public static List <ServiceDirectoryList> GetServiceDirectoryList(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);
//var Result = _DBTouchbase.ExecuteStoreQuery<ServiceDirectoryList>("CALL V3_USPGetServiceDirectoryList(?grpId,?updateOn)", param).ToList();
var Result = _DBTouchbase.ExecuteStoreQuery <ServiceDirectoryList>("CALL V6_USPGetServiceDirectoryList(?grpId,?moduleId,?updateOn)", param).ToList(); // Added by Nandu on 30/09/2016 Task--> Module replica
foreach (ServiceDirectoryList servDir in Result)
{
if (!string.IsNullOrEmpty(servDir.image))
{
string profile_Image = servDir.image.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/servicedirectory/Group" + search.groupId + "/thumb/";
servDir.image = path + profile_Image;
}
}
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public object GetServiceDirectoryList(ServiceDirectorySearch service)
{
dynamic TBServiceDirectoryResult;
List <object> ServiceDirectoryResult = new List <object>();
try
{
List <ServiceDirectoryList> Result = ServiceDirectory.GetServiceDirectoryList(service);
for (int i = 0; i < Result.Count; i++)
{
ServiceDirectoryResult.Add(new { ServiceDirResult = Result[i] });
}
if (ServiceDirectoryResult != null)
{
TBServiceDirectoryResult = new { status = "0", message = "success", updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), ServiceDirectoryResult };
}
else
{
TBServiceDirectoryResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBServiceDirectoryResult = new { status = "1", message = "failed" };
}
return(new { TBServiceDirectoryResult });
}
public static List <ServiceCategoryList> GetServiceDirCategoriesList(ServiceDirectorySearch search)
{
try
{
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("@grpId", search.groupId);
param[1] = new MySqlParameter("@moduleId", search.moduleId); // Added by Nandu Task--> Module replica
var Result = _DBTouchbase.ExecuteStoreQuery <ServiceCategoryList>("CALL V7_GetServiceCategoriesList(?grpId,?moduleId)", param).ToList(); // Added by Nandu Task--> Module replica
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
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
});
}
public static List <ServiceCategoryList> GetServiceDirCategoriesList(ServiceDirectorySearch search)
{
try
{
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("@grpId", search.groupId);
param[1] = new MySqlParameter("@moduleId", search.moduleId); // Added by Nandu Task--> Module replica
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreQuery <ServiceCategoryList>("CALL V7_GetServiceCategoriesList(?grpId,?moduleId)", param).ToList(); // Added by Nandu Task--> Module replica
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static ClsSeviceCategoryData GetServiceCategoriesData(ServiceDirectorySearch input)
{
try
{
MySqlParameter[] param = new MySqlParameter[4];
param[0] = new MySqlParameter("@grpId", input.groupId);
param[1] = new MySqlParameter("@moduleId", input.moduleId);
DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V8_GetServiceCategoriesList", param);
DataTable dtCategory = Result.Tables[0];
DataTable dtDirectory = Result.Tables[1];
List <ServiceCategoryList> ServiceCategoryList = new List <ServiceCategoryList>();
List <ServiceDirectoryList> ServiceDirectoryList = new List <ServiceDirectoryList>();
if (dtCategory.Rows.Count > 0)
{
ServiceCategoryList = GlobalFuns.DataTableToList <ServiceCategoryList>(dtCategory);
}
if (dtDirectory.Rows.Count > 0)
{
ServiceDirectoryList = GlobalFuns.DataTableToList <ServiceDirectoryList>(dtDirectory);
}
ClsSeviceCategoryData obj = new ClsSeviceCategoryData();
obj.Category = ServiceCategoryList;
obj.DirectoryData = ServiceDirectoryList;
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public object GetServiceCategoriesData(ServiceDirectorySearch service)
{
dynamic TBGetServiceCategoriesDataList;
try
{
ClsSeviceCategoryData Result = ServiceDirectory.GetServiceCategoriesData(service);
if (Result != null)
{
TBGetServiceCategoriesDataList = new { status = "0", message = "success", Result = Result };
}
else
{
TBGetServiceCategoriesDataList = new { status = "0", message = "Record not found" };
}
}
catch
{
TBGetServiceCategoriesDataList = new { status = "1", message = "failed" };
}
return(new { TBGetServiceCategoriesDataList });
}
// 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 });
}
