public int DL_InsUpdBedDetail(ML_CommonServices objML_CommonServices) { SqlParameter[] par = { new SqlParameter("@ID", objML_CommonServices.ID), new SqlParameter("@BedName", objML_CommonServices.BedName), new SqlParameter("@No_Of_Bed", objML_CommonServices.No_Of_Bed), new SqlParameter("@WardID", objML_CommonServices.WardName), new SqlParameter("@CreatedBy", objML_CommonServices.CraetedBy), new SqlParameter("@ModifyBy", objML_CommonServices.ModifyBy) }; return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpdBedDetail", par)); }
public int DL_InsUpdEmployeeMaster(ML_CommonServices objML_CommonServices) { SqlParameter[] par = { new SqlParameter("@EmployeeID", objML_CommonServices.ID), new SqlParameter("@FirstName", objML_CommonServices.FirstName), new SqlParameter("@LastName", objML_CommonServices.LastName), new SqlParameter("@DOB", objML_CommonServices.DOB), new SqlParameter("@Gender", objML_CommonServices.Gender), new SqlParameter("@MarriedStatus", objML_CommonServices.MarriedStatus), new SqlParameter("@Age", objML_CommonServices.Age), new SqlParameter("@Department", objML_CommonServices.Department), new SqlParameter("@MobileNo", objML_CommonServices.MobileNo), new SqlParameter("@EmailID", objML_CommonServices.EmailID), new SqlParameter("@Designation", objML_CommonServices.Designation), new SqlParameter("@Address", objML_CommonServices.Address), new SqlParameter("@City", objML_CommonServices.City), new SqlParameter("@State", objML_CommonServices.State), new SqlParameter("@Country", objML_CommonServices.Country), new SqlParameter("@Website", objML_CommonServices.Website), new SqlParameter("@CreatedBy", objML_CommonServices.CraetedBy), new SqlParameter("@ModifyBy", objML_CommonServices.ModifyBy) }; return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpdEmployeeMaster", par)); }
public int DL_DeleteEmployeeMaster(ML_CommonServices objML_CommonServices) { SqlParameter[] par = { new SqlParameter("@ID", objML_CommonServices.ID), }; return(SqlHelper.ExecuteNonQuery(con, "SPCN_EmployeeMaster_Delete", par)); }
public int DL_DeleteDesignation(ML_CommonServices objML_CommonServices) { SqlParameter[] par = { new SqlParameter("@ID", objML_CommonServices.ID), }; return(SqlHelper.ExecuteNonQuery(con, "SPCN_Designation_Delete", par)); }
public DataTable DL_SelectEmployeeMaster(ML_CommonServices objML_CommonServices) { SqlParameter[] par = { new SqlParameter("@ID", objML_CommonServices.ID), }; return(SqlHelper.ExecuteDataset(con, "SPCN_EmployeeMaster_Select", par).Tables[0]); }
public DataTable DL_BindBedMaster(ML_CommonServices objML_CommonServices) { SqlParameter[] par = { new SqlParameter("@ID", objML_CommonServices.ID), }; return(SqlHelper.ExecuteDataset(con, "SPCN_BindBedDetail", par).Tables[0]); }
public DataTable BL_SelectEmpolyeeMaster(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_SelectEmployeeMaster(objML_CommonServices)); }
public int BL_DeleteDesignation(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_DeleteDesignation(objML_CommonServices)); }
public DataTable BL_BindBedMaster(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_BindBedMaster(objML_CommonServices)); }
public DataTable BL_SelectWardMaster(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_SelectWardMaster(objML_CommonServices)); }
public DataTable BL_SelectDepartment(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_SelectDepartment(objML_CommonServices)); }
public DataTable BL_BindDesigantion(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_BindDesigantion(objML_CommonServices)); }
public int BL_InsUpdEmployeeMaster(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_InsUpdEmployeeMaster(objML_CommonServices)); }
public int BL_InsUpdDesignation(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_InsUpdDesignation(objML_CommonServices)); }
public int BL_InsUpdDepartment(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_InsUpdDepartment(objML_CommonServices)); }
public DataTable DL_BindDesigantion(ML_CommonServices objML_CommonServices) { SqlParameter[] par = { new SqlParameter("@ID", objML_CommonServices.ID), }; return(SqlHelper.ExecuteDataset(con, "SPCN_Designation_Bind", par).Tables[0]); }
public DataTable BL_SelectDesingation(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_SelectDesignation(objML_CommonServices)); }
public int BL_InsUpdBedDetail(ML_CommonServices objML_CommonServices) { return(objDL_CommonServices.DL_InsUpdBedDetail(objML_CommonServices)); }