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