public int Add(CustomerWeeklyOff_VM Model) { int result = 0; try { using (var db = new DBConnection()) { var dt_CustomerWeeklyOffName = new DataTable(); if (Model.CustomerWeeklyOffName_TableTypeList != null && Model.CustomerWeeklyOffName_TableTypeList.Count > 0) { dt_CustomerWeeklyOffName = ConvertToDatatable(Model.CustomerWeeklyOffName_TableTypeList); } else { dt_CustomerWeeklyOffName = ConvertToDatatable(new List <CustomerWeeklyOffName_TableType_VM>()); } var dt_CustomerLocation = new DataTable(); if (Model.CustomerLocation_TableTypeList != null && Model.CustomerLocation_TableTypeList.Count > 0) { dt_CustomerLocation = ConvertToDatatable(Model.CustomerLocation_TableTypeList); } else { dt_CustomerLocation = ConvertToDatatable(new List <CustomerLocationList_VM>()); } var par = new SqlParameter[] { //new SqlParameter("@p_LocationID", GetDBNULL(Model.LocationID)), new SqlParameter("@p_CustomerLocation", dt_CustomerLocation) { TypeName = "CustomerLocation_TableType" }, new SqlParameter("@p_CustomerWeeklyOffName", dt_CustomerWeeklyOffName) { TypeName = "CustomerWeeklyOffName_TableType" }, new SqlParameter("@p_LanguageCode", GetDBNULLString(Model.CurrentLanguageCode)), new SqlParameter("@p_UTCOffset", GetDBNULL(Model.CurrentUTCOffset)), new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)), new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)), new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)), new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint)), }; db.ExecuteNonQueryRollBack("AddCustomerWeeklyOff", par); result = 1; } } catch (Exception ex) { logger.Error("CustomerWeeklyOffRepository_Add Error: ", ex); throw; } return(result); }
public int Delete(CustomerWeeklyOff_VM Model) { int result = 0; try { using (var db = new WebPortalEntities()) { result = db.DeleteCustomerWeeklyOff(Model.LocationID, Model.DayName, Model.CurrentLanguageCode, Model.CurrentUTCOffset, Model.CurrentEndUserID, Model.CurrentUserRoleID, Model.CurrentScreenID, Model.AccessPoint); db.SaveChanges(); } } catch (Exception ex) { logger.Error("CustomerWeeklyOffRepository_Delete Error: ", ex); throw; } return(result); }
public List <CustomerWeeklyOff_VM> GetData(CustomerWeeklyOff_VM Model) { List <CustomerWeeklyOff_VM> query = new List <CustomerWeeklyOff_VM>(); try { using (var db = new DBConnection()) { var ds = new DataSet(); var par = new SqlParameter[] { new SqlParameter("@p_CustomerID", GetDBNULL(Model.CustomerID)), new SqlParameter("@p_DayName", GetDBNULL(Model.DayName)), new SqlParameter("@p_LanguageCode", GetDBNULLString(Model.CurrentLanguageCode)), new SqlParameter("@p_UTCOffset", GetDBNULL(Model.CurrentUTCOffset)), new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)), new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)), new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)), new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint)), }; ds = db.ExecuteDataSet("GetCustomerWeeklyOff", par); query = ConvertToList <CustomerWeeklyOff_VM>(ds.Tables[0]); if (Model.IsChildResult == true) { query[0].CustomerWeeklyOffNameList = ConvertToList <CustomerWeeklyOffName_VM>(ds.Tables[1]); } } } catch (Exception ex) { logger.Error("CustomerWeeklyOffRepository_GetData Error: ", ex); throw; } return(query); }