public DataTable Customers_InsertUpdate(UserBase userBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@Id", userBase.ID), new MyParameter("@FirstName", userBase.FirstName), new MyParameter("@LastName", userBase.LastName), new MyParameter("@Password", userBase.Password), new MyParameter("@EMail", userBase.EMail), new MyParameter("@UserName", userBase.UserName), new MyParameter("@Roles", userBase.CustomerRoles), new MyParameter("@Phone", userBase.Phone), new MyParameter("@Country", userBase.Country), new MyParameter("@State", userBase.State), new MyParameter("@City", userBase.City), new MyParameter("@Zip", userBase.Zip), new MyParameter("@LicenseExpiryDate", userBase.LicenseExpiryDate), new MyParameter("@CustomerLogo", userBase.CustomerLogo) }; Common.Set_Procedures("LicensedCustomers_IU"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable PictureVideos_Insert(PictureVideosBase pictureVideoBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@Assigned", pictureVideoBase.Assigned), new MyParameter("@MediaExtention", pictureVideoBase.MediaExtention), new MyParameter("@MediaName", pictureVideoBase.MediaName), new MyParameter("@Description", pictureVideoBase.Description), new MyParameter("@PicType", pictureVideoBase.PicType), new MyParameter("@DefaultPic", pictureVideoBase.DefaultPic), // new MyParameter("@EncodeArray",pictureVideoBase.EncodeArray), new MyParameter("@EncodeState", pictureVideoBase.EncodeState), new MyParameter("@FilePath", pictureVideoBase.FilePath), new MyParameter("@EncodeFaceValues", pictureVideoBase.EncodeFaceValues), new MyParameter("@FaceValue", pictureVideoBase.FaceValue), new MyParameter("@PictureType", pictureVideoBase.PictureType), new MyParameter("@SubFeatureID", pictureVideoBase.SubFeatureID), new MyParameter("@SubFeaturesid", pictureVideoBase.SubFeaturesid) }; Common.Set_Procedures("PictureVideos_Insert"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable SubjectEmployeePicture_Insert(CommonPictureVideosBase pictureVideoBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@ID", pictureVideoBase.ID), new MyParameter("@IncidentID", pictureVideoBase.IncidentID), new MyParameter("@MediaID", pictureVideoBase.MediaID), new MyParameter("@QuestionID", pictureVideoBase.QuestionID), new MyParameter("@Observation", pictureVideoBase.Observation), new MyParameter("@MediaType", pictureVideoBase.MediaType), new MyParameter("@Type", pictureVideoBase.Type) }; Common.Set_Procedures("SubjectEmployeePicture_Insert"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
// *DN public DataTable Corporate_update(CorporateBase corporateBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@Corporate_logo", corporateBase.Corporate_logo), //AB New new MyParameter("@Customer_logo", corporateBase.Customer_logo), new MyParameter("@Corporate_background", corporateBase.Corporate_background), new MyParameter("@Corporate_back_type", corporateBase.Corporate_back_type), new MyParameter("@Corporate_action", corporateBase.Corporate_action) }; Common.Set_Procedures("Corporate_update"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable Users_InsertUpdate(UserBase userBase) { dtContainer = new DataTable(); try { List <MyParameter> myparamslist = new List <MyParameter>(); myparamslist.Add(new MyParameter("@ID", userBase.ID)); myparamslist.Add(new MyParameter("@FirstName", userBase.FirstName)); myparamslist.Add(new MyParameter("@LastName", userBase.LastName)); if (userBase.ID == 0) { myparamslist.Add(new MyParameter("@Password", userBase.Password)); myparamslist.Add(new MyParameter("@PasswordDate", userBase.PasswordDate)); } myparamslist.Add(new MyParameter("@UserCanChangePassword", userBase.UserCanChangePassword)); myparamslist.Add(new MyParameter("@Skills", userBase.Skills)); myparamslist.Add(new MyParameter("@UnitID", userBase.UnitID)); myparamslist.Add(new MyParameter("@RegNumber", userBase.RegNumber)); myparamslist.Add(new MyParameter("@IsDispatchable", userBase.IsDispatchable)); myparamslist.Add(new MyParameter("@Initials", userBase.Initials)); myparamslist.Add(new MyParameter("@EMail", userBase.EMail)); myparamslist.Add(new MyParameter("@UserName", userBase.UserName)); myparamslist.Add(new MyParameter("@UserGuid ", userBase.UserGuid)); myparamslist.Add(new MyParameter("@Roles", userBase.Roles)); MyParameter[] myParams = myparamslist.ToArray(); //MyParameter[] myParams = { // new MyParameter("@ID", userBase.ID), // new MyParameter("@FirstName", userBase.FirstName), // new MyParameter("@LastName", userBase.LastName), // //new MyParameter("@Password", userBase.Password), // //new MyParameter("@PasswordDate", userBase.PasswordDate), // new MyParameter("@UserCanChangePassword", userBase.UserCanChangePassword), // new MyParameter("@Skills", userBase.Skills), // new MyParameter("@UnitID", userBase.UnitID), // new MyParameter("@RegNumber", userBase.RegNumber), // new MyParameter("@IsDispatchable", userBase.IsDispatchable), // new MyParameter("@Initials", userBase.Initials), // new MyParameter("@EMail", userBase.EMail) , // new MyParameter("@UserName", userBase.UserName), // new MyParameter("@UserGuid ", userBase.UserGuid), // new MyParameter("@Roles", userBase.Roles) // }; Common.Set_Procedures("Users_IU"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable SubMenu_LoadAll() { dtContainer = new DataTable(); try { MyParameter[] myParams = { }; Common.Set_Procedures("SubMenu_LoadAll"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable Customer_LoadById() { dtContainer = new DataTable(); try { MyParameter[] myParams = { }; Common.Set_Procedures("LicensedCustomers_LoadById"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable PictureVideos_Delete(PictureVideosBase pictureVideoBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@MediaID", pictureVideoBase.MediaID) }; Common.Set_Procedures("PictureVideos_Delete"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable EventReview_DeleteById(EventReviewBase EventBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@EventReviewID", EventBase.EventReviewID) }; Common.Set_Procedures("EventReview_DeleteById"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable SubMenuPermissions(RoleBase roleBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@RoleID", roleBase.ID) }; Common.Set_Procedures("SubMenuPermissions"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable User_LoadById(UserBase userBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@ID", userBase.ID) }; Common.Set_Procedures("User_LoadById"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable Menus_LoadByRoleId(RoleBase roleBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@Id", roleBase.ID), }; Common.Set_Procedures("GetCustomerPermissions_ByRoleId"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable Login_Load(UserBase userBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@UserName", userBase.UserName), new MyParameter("@Password", userBase.Password) }; Common.Set_Procedures("SuperAdminLogin"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable UserRole_IU(RoleBase roleBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@Id", roleBase.ID), new MyParameter("@RoleName", roleBase.RoleName) }; Common.Set_Procedures("UserRoles_IU"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable PicturesVideos_LoadAll(PictureVideosBase pictureVideosBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@PictureType", pictureVideosBase.PictureType), new MyParameter("@SubFeatureID", pictureVideosBase.SubFeatureID), new MyParameter("@SubFeaturesid", pictureVideosBase.SubFeaturesid) }; Common.Set_Procedures("PicturesVideos_LoadAll"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable RoleAuthorities_IU(RoleBase roleBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@ID", roleBase.ID), new MyParameter("@WatchListEdit", roleBase.WatchListEdit), new MyParameter("@WatchList", roleBase.WatchList), new MyParameter("@Visitors", roleBase.Visitors), new MyParameter("@Vehicles", roleBase.Vehicles), new MyParameter("@Users", roleBase.Users), new MyParameter("@TransactionLog", roleBase.TransactionLog), new MyParameter("@Subjects", roleBase.Subjects), new MyParameter("@SubjectLinked", roleBase.SubjectLinked), new MyParameter("@SharedInformation", roleBase.SharedInformation), new MyParameter("@SharedEmails", roleBase.SharedEmails), new MyParameter("@ServicesCodes", roleBase.ServicesCodes), new MyParameter("@Services", roleBase.Services), new MyParameter("@RestrictedSubjects", roleBase.RestrictedSubjects), new MyParameter("@ReportOptions", roleBase.ReportOptions), new MyParameter("@QuickIncident", roleBase.QuickIncident), new MyParameter("@Permissions", roleBase.Permissions), new MyParameter("@OccurrenceWrite", roleBase.OccurrenceWrite), new MyParameter("@OccurrenceAdministration", roleBase.OccurrenceAdministration), new MyParameter("@Occurrence", roleBase.Occurrence), new MyParameter("@NatureofIncidentCodes", roleBase.NatureofIncidentCodes), new MyParameter("@NatureofCallCodes", roleBase.NatureofCallCodes), new MyParameter("@MultipleAuthorReports", roleBase.MultipleAuthorReports), new MyParameter("@Messages", roleBase.Messages), new MyParameter("@MessageGroups", roleBase.MessageGroups), new MyParameter("@MessageAlerts", roleBase.MessageAlerts), new MyParameter("@MediaReview", roleBase.MediaReview), new MyParameter("@MediaCopy", roleBase.MediaCopy), new MyParameter("@MediaCaptureOptions", roleBase.MediaCaptureOptions), new MyParameter("@MediaCapture", roleBase.MediaCapture), new MyParameter("@LCTTotals", roleBase.LCTTotals), new MyParameter("@LCTDetails", roleBase.LCTDetails), new MyParameter("@LabelNames", roleBase.LabelNames), new MyParameter("@Involved", roleBase.Involved), new MyParameter("@IncidentProtection", roleBase.IncidentProtection), new MyParameter("@IncidentDetails", roleBase.IncidentDetails), new MyParameter("@IncidentDescription", roleBase.IncidentDescription), new MyParameter("@Identification", roleBase.Identification), new MyParameter("@GameLocations", roleBase.GameLocations), new MyParameter("@ForeignRates", roleBase.ForeignRates), new MyParameter("@Features", roleBase.Features), new MyParameter("@EventsMedia", roleBase.EventsMedia), new MyParameter("@Events", roleBase.Events), new MyParameter("@Equipment", roleBase.Equipment), new MyParameter("@EmployeeVariance", roleBase.EmployeeVariance), new MyParameter("@EmployeePersonal", roleBase.EmployeePersonal), new MyParameter("@EmployeePaceAudit", roleBase.EmployeePaceAudit), new MyParameter("@EmployeeNotes", roleBase.EmployeeNotes), new MyParameter("@EmployeeLinked", roleBase.EmployeeLinked), new MyParameter("@EmployeeLicense", roleBase.EmployeeLicense), new MyParameter("@EmployeeIPVR", roleBase.EmployeeIPVR), new MyParameter("@EmployeeInvolved", roleBase.EmployeeInvolved), new MyParameter("@EmployeeIncidentDetails", roleBase.EmployeeIncidentDetails), new MyParameter("@EmployeeGameAudit", roleBase.EmployeeGameAudit), new MyParameter("@EmployeeAddress", roleBase.EmployeeAddress), new MyParameter("@Employee", roleBase.Employee), new MyParameter("@Emails", roleBase.Emails), new MyParameter("@DropdownCodes", roleBase.DropdownCodes), new MyParameter("@DisputeOffense", roleBase.DisputeOffense), new MyParameter("@DispatchDispatchers", roleBase.DispatchDispatchers), new MyParameter("@DispatchCallTakers", roleBase.DispatchCallTakers), new MyParameter("@DispatchAdministration", roleBase.DispatchAdministration), new MyParameter("@DatabaseOptions", roleBase.DatabaseOptions), new MyParameter("@CustomReports", roleBase.CustomReports), new MyParameter("@CombineSubjects", roleBase.CombineSubjects), new MyParameter("@ChangeRoles", roleBase.ChangeRoles), new MyParameter("@CashTransactions", roleBase.CashTransactions), new MyParameter("@Banned", roleBase.Banned), new MyParameter("@Badges", roleBase.Badges), new MyParameter("@AuditQuestions", roleBase.AuditQuestions), new MyParameter("@ApplicationOptions", roleBase.ApplicationOptions), new MyParameter("@Alias", roleBase.Alias), new MyParameter("@Address", roleBase.Address), new MyParameter("@AccessCards", roleBase.AccessCards) }; Common.Set_Procedures("RoleAuthorities_IU"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }