public DataTable VerifyOTP(string email, string otp) { try { General objGeneral = new General(); objGeneral.AddParameterWithValueToSQLCommand("@Email", email); objGeneral.AddParameterWithValueToSQLCommand("@OTP", otp); ds = objGeneral.GetDatasetByCommand_SP("SP_VerifyOTP"); } catch (Exception ex) { } return(ds.Tables[0]); }
public DataTable CheckCurrentPassword(string mob, string password) { try { General objGeneral = new General(); objGeneral.AddParameterWithValueToSQLCommand("@Mobile", mob); objGeneral.AddParameterWithValueToSQLCommand("@Password", password); ds = objGeneral.GetDatasetByCommand_SP("SP_CheckCurrentPassword"); } catch (Exception ex) { } return(ds.Tables[0]); }
public int AddEmployeeFacility(int employeeID, string FacilityID) { int _isInserted = -1; try { General objGeneral = new General(); objGeneral.AddParameterWithValueToSQLCommand("@EmployeeID", employeeID); objGeneral.AddParameterWithValueToSQLCommand("@FacilityID", FacilityID); _isInserted = objGeneral.GetExecuteNonQueryByCommand_SP("SP_AddEmployeeFacility"); } catch (Exception ex) { } return(_isInserted); }
public int UpdateOTP(string email, string otp) { int _isInserted = -1; try { General objGeneral = new General(); objGeneral.AddParameterWithValueToSQLCommand("@Email", email); objGeneral.AddParameterWithValueToSQLCommand("@OTP", otp); _isInserted = objGeneral.GetExecuteNonQueryByCommand_SP("SP_UpdateOTP"); } catch (Exception ex) { } return(_isInserted); }
public int ChangePassword(string mobile, string password) { int _isUpdated = -1; try { General objGeneral = new General(); objGeneral.AddParameterWithValueToSQLCommand("@Mobile", mobile); objGeneral.AddParameterWithValueToSQLCommand("@Password", password); _isUpdated = objGeneral.GetExecuteNonQueryByCommand_SP("SP_UpdatePasswordByMobile"); } catch (Exception ex) { } return(_isUpdated); }
public DataTable GetFacilityMaster() { try { General objGeneral = new General(); objGeneral.AddParameterWithValueToSQLCommand("@mode", 4); ds = objGeneral.GetDatasetByCommand_SP("GET_Common"); } catch (Exception ex) { } return(ds.Tables[0]); }
public DataTable CheckEmailExists(string email) { try { General objGeneral = new General(); objGeneral.AddParameterWithValueToSQLCommand("@Email", email); ds = objGeneral.GetDatasetByCommand_SP("SP_CheckEmaiLExists"); } catch (Exception ex) { } return(ds.Tables[0]); }
public int RemoveEmployee(int employeeID) { int _isDeleted = -1; try { General objGeneral = new General(); objGeneral.AddParameterWithValueToSQLCommand("@EmployeeID", employeeID); _isDeleted = objGeneral.GetExecuteScalarByCommand_SP("SP_RemoveEmployee"); } catch (Exception ex) { } return(_isDeleted); }
public int UpdateEmployee(Employee objEmployee) { int _isInserted = -1; try { General objGeneral = new General(); objGeneral.AddParameterWithValueToSQLCommand("@EmployeeID", objEmployee.EmployeeID); objGeneral.AddParameterWithValueToSQLCommand("@Photo", objEmployee.Photo); objGeneral.AddParameterWithValueToSQLCommand("@Mobile", objEmployee.Mobile); objGeneral.AddParameterWithValueToSQLCommand("@Name", objEmployee.Name); objGeneral.AddParameterWithValueToSQLCommand("@Email", objEmployee.Email); objGeneral.AddParameterWithValueToSQLCommand("@Password", objEmployee.Password); objGeneral.AddParameterWithValueToSQLCommand("@Designation", objEmployee.Designation); objGeneral.AddParameterWithValueToSQLCommand("@Department", objEmployee.Department); _isInserted = objGeneral.GetExecuteScalarByCommand_SP("SP_UpdateEmployee"); } catch (Exception ex) { } return(_isInserted); }