public static List <DesignationOfficewise> GetDesignationOfficewiseByOfficeID(int OfficeID = -1)
{
try
{
DataTable DesignationOfficewiseRows = DesignationOfficewiseDataAccess.GetInstance.GetDesignationOfficewiseByOffice(OfficeID);
List <DesignationOfficewise> _DesignationOfficewiseList = new List <DesignationOfficewise>();
foreach (DataRow dr in DesignationOfficewiseRows.Rows)
{
DesignationOfficewise _DesignationOfficewise = new DesignationOfficewise();
_DesignationOfficewise.DesignationOfficewiseID = int.Parse(dr["DesignationOfficewiseID"].ToString());
_DesignationOfficewise.DESIGNATION.DesignationID = int.Parse(dr["DesignationID"].ToString());
_DesignationOfficewise.DESIGNATION.DesignationDescription = (dr["DesignationDescription"].ToString());
_DesignationOfficewise.Office.OfficeID = int.Parse(dr["OfficeID"].ToString());
_DesignationOfficewise.IsActive = Boolean.Parse(dr["IsActive"].ToString());
_DesignationOfficewise.IsDeleted = Boolean.Parse(dr["IsDeleted"].ToString());
_DesignationOfficewiseList.Add(_DesignationOfficewise);
}
return(_DesignationOfficewiseList);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
//public int InsertDesignationOfficewise( string DesignationIds)
//{
// 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("@DesignationIDs", SqlDbType.VarChar, DesignationIds));
// SqlCmd.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
// SqlCmd.CommandText = "pHRM_DesignationsOfficewise_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 int InsertDesignationOfficewise(DesignationOfficewise _DesignationOfficewise)
{
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("@DesignationID", SqlDbType.Int, _DesignationOfficewise.DesignationID));
SqlCmd.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
SqlCmd.CommandText = "pHRM_DesignationsOfficewise_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 int UpdateDesignationOfficewise(DesignationOfficewise _DesignationOfficewise)
{
try
{
return(DesignationOfficewiseDataAccess.GetInstance.UpdateDesignationOfficewise(_DesignationOfficewise));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
//public int InsertDesignationOfficewise(string DesignationIds)
//{
// try
// {
// return DesignationOfficewiseIntegration.InsertDesignationOfficewise(DesignationIds);
// }
// catch (Exception ex)
// {
// throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
// }
//}
public int InsertDesignationOfficewise(DesignationOfficewise _DesignationOfficewise)
{
try
{
return(DesignationOfficewiseIntegration.InsertDesignationOfficewise(_DesignationOfficewise));
}
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;
DesignationOfficewise ObjDesg = new DesignationOfficewise();
List <DesignationOfficewise> thisDesignationOfficewiseList = new List <DesignationOfficewise>();
foreach (GridViewRow therow in gview_DesignationSelect.Rows)
{
DesignationOfficewise thisDesignationOfficewise = new DesignationOfficewise();
CheckBox chkb = (CheckBox)therow.FindControl("chk_Add");
Label theOfficelabel = (Label)therow.FindControl("lbl_DesignationOfficeId");
if (int.Parse(theOfficelabel.Text) == 0)
{
if (chkb.Checked)
{
ObjDesg.DesignationID = int.Parse(therow.Cells[2].Text);
result = DesignationOfficewiseManagement.GetInstance.InsertDesignationOfficewise(ObjDesg);
lbl_TheMessage.Text = GetDataOperationResult(result, "Designation", MicroEnums.DataOperation.AddNew);
}
}
else if (int.Parse(theOfficelabel.Text) != 0)
{
ObjDesg.DesignationID = int.Parse(therow.Cells[2].Text);
if (!chkb.Checked)
{
ObjDesg.IsActive = false;
}
else
{
ObjDesg.IsActive = true;
}
ObjDesg.DesignationOfficewiseID = int.Parse(theOfficelabel.Text);
result = DesignationOfficewiseManagement.GetInstance.UpdateDesignationOfficewise(ObjDesg);
lbl_TheMessage.Text = GetDataOperationResult(result, "Designation", MicroEnums.DataOperation.Edit);
}
}
if (!string.IsNullOrEmpty(lbl_TheMessage.Text))
{
dialog_Message.Show();
}
}
public int UpdateDesignationOfficewise(DesignationOfficewise _DesignationOfficewise)
{
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("DesignationOfficewiseID", SqlDbType.Int, _DesignationOfficewise.DesignationOfficewiseID));
SqlCmd.Parameters.Add(GetParameter("@DesignationID", SqlDbType.Int, _DesignationOfficewise.DESIGNATION.DesignationID));
SqlCmd.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID));
if (_DesignationOfficewise.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_DesignationsOfficewise_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));
}
}
