public string AddEmployee(EmployeeProperties Epr)
{
try
{
SqlCommand com = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@First_Name", Epr.First_Name));
param.Add(new SqlParameter("@Last_Name", Epr.Last_Name));
param.Add(new SqlParameter("@Address1", Epr.Address1));
param.Add(new SqlParameter("@Address2", Epr.Address2));
param.Add(new SqlParameter("@Mobile1", Epr.Mobile1));
param.Add(new SqlParameter("@Mobile2", Epr.Mobile2));
param.Add(new SqlParameter("@Active", Epr.Active));
param.Add(new SqlParameter("@RestCode", Epr.RestCode));
param.Add(new SqlParameter("@Remarks", Epr.Remarks));
param.Add(new SqlParameter("@UserTypeId", Epr.UserTypeId));
param.Add(new SqlParameter("@PhotoUrl", Epr.Image));
param.Add(new SqlParameter("@EmailId", Epr.EmailId));
param.Add(new SqlParameter("@UserCode", Epr.UserCode));
// param.Add(new SqlParameter("@EmpCode", Epr.EmpCode));
return(_objdal.fnAdddata("AddEmployee", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetAllEmployeesbyRestCode(EmployeeProperties Emp)
{
DataTable dt = new DataTable();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@RestCode", Emp.RestCode));
return(_objdal.fngetdata("[getAllEmployeesbyRestCode]", param.ToArray())); //orderStatusByOrderId
}
//To Get Employee based on Employee Code
public DataTable GetEmpByEmpCode(EmployeeProperties Emp)
{
try
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@EmpCode", Emp.EmpCode));
return(_objdal.fngetdata("SP_GetEmployee", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public string ChangePWforEMP(EmployeeProperties Epr)
{
try
{
SqlCommand com = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@RestCode", Epr.RestCode));
param.Add(new SqlParameter("@UserCode", Epr.UserCode));
param.Add(new SqlParameter("@EmpCode", Epr.EmpCode));
return(_objdal.fnAdddata("spCreateNewPasswordForEmployee", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public string AddEmpDtlstoCustomer(EmployeeProperties Epr)
{
try
{
SqlCommand com = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@customerphone", Epr.CustPhoneNumber));
param.Add(new SqlParameter("@custfname", Epr.CustomerFName));
param.Add(new SqlParameter("@custlname", Epr.CustomerLName));
param.Add(new SqlParameter("@billaddress", Epr.Billing_Address));
param.Add(new SqlParameter("@Delivery_Addresss", Epr.Delivery_Addresss));
param.Add(new SqlParameter("@custtypeid", Epr.CustomerTypeId));
return(_objdal.fnAdddata("spinsertEmpIntoCustomer", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
