public int InsertDepartmentOfficewise(DepartmentOfficewise _DepartmentOfficewise)
{
try
{
int ReturnValue = 0;
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID));
SqlCmd.Parameters.Add(GetParameter("@DepartmentID", SqlDbType.Int, _DepartmentOfficewise.DepartmentID));
SqlCmd.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
SqlCmd.CommandText = "pHRM_DepartmentsOfficewise_Insert";
ExecuteStoredProcedure(SqlCmd);
ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString());
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static List <DepartmentOfficewise> GetDepartmentOfficewiseByOfficeID(int OfficeID = -1)
{
try
{
DataTable DepartmentOfficewiseRows = DepartmentOfficewiseDataAccess.GetInstance.GetDepartmentOfficewiseByOffice(OfficeID);
List <DepartmentOfficewise> _DepartmentOfficewiseList = new List <DepartmentOfficewise>();
foreach (DataRow dr in DepartmentOfficewiseRows.Rows)
{
DepartmentOfficewise _DepartmentOfficewise = new DepartmentOfficewise();
_DepartmentOfficewise.DepartmentOfficewiseID = int.Parse(dr["DepartmentOfficewiseID"].ToString());
_DepartmentOfficewise.DEPARTMENT.DepartmentID = int.Parse(dr["DepartmentID"].ToString());
_DepartmentOfficewise.Office.OfficeID = int.Parse(dr["OfficeID"].ToString());
_DepartmentOfficewise.IsActive = (dr["IsActive"].ToString() == "True" ? true : false);
_DepartmentOfficewise.IsDeleted = (dr["IsDeleted"].ToString() == "True" ? true : false);
_DepartmentOfficewiseList.Add(_DepartmentOfficewise);
}
return(_DepartmentOfficewiseList);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int UpdateDepartmentOfficewise(DepartmentOfficewise _DepartmentOfficewise)
{
try
{
return(DepartmentOfficewiseDataAccess.GetInstance.UpdateDepartmentOfficewise(_DepartmentOfficewise));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public int InsertDepartmentOfficewise(DepartmentOfficewise _DepartmentOfficewise)
{
try
{
return(DepartmentOfficewiseIntegration.InsertDepartmentOfficewise(_DepartmentOfficewise));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
protected void btn_Apply_Click(object sender, EventArgs e)
{
int result = (int)MicroEnums.DataOperationResult.Failure;
DepartmentOfficewise theDepartmentOfficewise = new DepartmentOfficewise();
List <DepartmentOfficewise> thisDepartmentOfficewiseList = new List <DepartmentOfficewise>();
foreach (GridViewRow therow in gview_DepartmentSelect.Rows)
{
DepartmentOfficewise thisDepartmentOfficewise = new DepartmentOfficewise();
CheckBox chkb = (CheckBox)therow.FindControl("chk_Add");
Label theOfficelabel = (Label)therow.FindControl("lbl_DepartmentOfficeId");
if (int.Parse(theOfficelabel.Text) == 0)
{
if (chkb.Checked)
{
theDepartmentOfficewise.DepartmentID = int.Parse(therow.Cells[2].Text);
result = DepartmentOfficewiseManagement.GetInstance.InsertDepartmentOfficewise(theDepartmentOfficewise);
lbl_TheMessage.Text = GetDataOperationResult(result, "Department", MicroEnums.DataOperation.AddNew);
}
}
else if (int.Parse(theOfficelabel.Text) != 0)
{
theDepartmentOfficewise.DepartmentID = int.Parse(therow.Cells[2].Text);
if (!chkb.Checked)
{
theDepartmentOfficewise.IsActive = false;
}
else
{
theDepartmentOfficewise.IsActive = true;
}
theDepartmentOfficewise.DepartmentOfficewiseID = int.Parse(theOfficelabel.Text);
result = DepartmentOfficewiseManagement.GetInstance.UpdateDepartmentOfficewise(theDepartmentOfficewise);
lbl_TheMessage.Text = GetDataOperationResult(result, "Department", MicroEnums.DataOperation.Edit);
}
}
if (!string.IsNullOrEmpty(lbl_TheMessage.Text))
{
dialog_Message.Show();
}
}
public int UpdateDepartmentOfficewise(DepartmentOfficewise _DepartmentOfficewise)
{
try
{
int ReturnValue = 0;
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(GetParameter("DepartmentOfficewiseID", SqlDbType.Int, _DepartmentOfficewise.DepartmentOfficewiseID));
SqlCmd.Parameters.Add(GetParameter("@DepartmentID", SqlDbType.Int, _DepartmentOfficewise.DEPARTMENT.DepartmentID));
SqlCmd.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID));
if (_DepartmentOfficewise.IsActive == true)
{
SqlCmd.Parameters.Add(GetParameter("@IsActive", SqlDbType.Bit, 1));
}
else
{
SqlCmd.Parameters.Add(GetParameter("@IsActive", SqlDbType.Bit, 0));
}
SqlCmd.Parameters.Add(GetParameter("@DateModified", SqlDbType.DateTime, DateTime.Now));
SqlCmd.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
SqlCmd.CommandText = "pHRM_DepartmentsOfficewise_Update";
ExecuteStoredProcedure(SqlCmd);
ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString());
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
