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