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