public DataSet CreaetNewEmployee(JoinEmployeeBOL objoinEmployeeBOL) { DataSet dsEmployeeCreated = new DataSet(); dsEmployeeCreated = objJoinEmployeeDAL.CreateNewEmployee(objoinEmployeeBOL); return(dsEmployeeCreated); }
public DataSet CheckUserNameEmail(JoinEmployeeBOL objoinEmployeeBOL) { DataSet CheckUserNameEmail = new DataSet(); CheckUserNameEmail = objJoinEmployeeDAL.CheckUserNameEmailAlreadyExist(objoinEmployeeBOL); return(CheckUserNameEmail); }
public Int64 GetLatestEmployeeCode(JoinEmployeeBOL objJoinEmployeeBOL) { Int64 latestEmployeeCode; latestEmployeeCode = objJoinEmployeeDAL.GetLatestEmployeeCode(objJoinEmployeeBOL); return(latestEmployeeCode); }
public Int64 GetLatestEmployeeCode(JoinEmployeeBOL objJoinEmployeeBOL) { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@IsContract", SqlDbType.Int); param[0].Value = objJoinEmployeeBOL.IsContract; return(Convert.ToInt64(SqlHelper.ExecuteScalar(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "GetLatestEmployeecode", param))); }
public DataSet CheckUserNameEmailAlreadyExist(JoinEmployeeBOL objoinEmployeeBOL) { DataSet CheckUserNameEmail = new DataSet(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@UserName", SqlDbType.NVarChar); param[0].Value = objoinEmployeeBOL.UserName; param[1] = new SqlParameter("@EmailId", SqlDbType.NVarChar); param[1].Value = objoinEmployeeBOL.EmailId; return(CheckUserNameEmail = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "CheckUserNameEmailExist", param)); }
public DataSet CreateNewEmployee(JoinEmployeeBOL objoinEmployeeBOL) { DataSet dsEmployeeCreated; SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@EmployeeCode", SqlDbType.Int); param[0].Value = objoinEmployeeBOL.Employeecode; param[1] = new SqlParameter("@UserName", SqlDbType.NVarChar); param[1].Value = objoinEmployeeBOL.UserName; param[2] = new SqlParameter("@EmailId", SqlDbType.NVarChar); param[2].Value = objoinEmployeeBOL.EmailId; param[3] = new SqlParameter("@CandidateId", SqlDbType.Int); param[3].Value = objoinEmployeeBOL.CandidateId; param[4] = new SqlParameter("@JoiningDate", SqlDbType.DateTime); param[4].Value = objoinEmployeeBOL.JoiningDate; return(dsEmployeeCreated = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "AddNewEmployee", param)); }