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