public string GetDesignation(DesignationBO designationBO) { SQLHelper helper = SQLHelper.GetInstance(this.connectionString); try { helper.OpenConnection(); query = @" SELECT [DesignationID] as DesignationCD,[DesignationName] as DesignationName FROM [dbo].[DesignationMaster] WHERE [DesignationID] = " + designationBO.DesignationCD; ds = helper.ExecuteDataSet(query); } catch (Exception ex) { string err = ex.Message; } finally { helper.CloseConnection(); } if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { return(StringUtil.SerializeObjectToJSON(ds.Tables[0])); } else { return("DB_ERROR : " + dbErrMsg); } }
/// <summary> /// UpdateDesignation() is a function which takes DesignationBO as parameter and update its data in database. /// It returns the number of rows affected by the operation which is 1 in success and 0 in failure. /// </summary> /// <param name="designationBO">An object of DesignationBO class which is used to hold the name and id of designation.</param> /// <returns>int</returns> public int UpdateDesignation(DesignationBO designationBO) { SQLHelper helper = SQLHelper.GetInstance(this.connectionString); int numberOfRowImpacted = 0; try { helper.OpenConnection(); query = @" UPDATE [dbo].[DesignationMaster] SET [DesignationName] = '" + designationBO.DesignationName + @"' WHERE [DesignationID] = " + designationBO.DesignationCD; numberOfRowImpacted = helper.ExecuteNonQuery(query); } catch (Exception ex) { numberOfRowImpacted = -1; } finally { helper.CloseConnection(); } return(numberOfRowImpacted); }
/// <summary> /// AddDesignation() is a function which takes DesignationBO as parameter and insert its data in database. /// It returns the number of rows affected by the operation which is 1 in success and 0 in failure. /// </summary> /// <param name="designationBO">An object of DesignationBO class which is used to hold the name and id of designation.</param> /// <returns>int</returns> public int AddDesignation(DesignationBO designationBO) { SQLHelper helper = SQLHelper.GetInstance(this.connectionString); int numberOfRowImpacted = 0; try { helper.OpenConnection(); query = @" INSERT INTO [dbo].[DesignationMaster] ([DesignationID],[DesignationName]) VALUES ( CAST((SELECT TOP 1 d.[DesignationID] FROM [DesignationMaster] as d ORDER BY CAST(d.[DesignationID] as int) DESC)+1 as varchar),'" + designationBO.DesignationName + @"')"; numberOfRowImpacted = helper.ExecuteNonQuery(query); } catch (Exception ex) { numberOfRowImpacted = -1; } finally { helper.CloseConnection(); } return(numberOfRowImpacted); }
public static bool UpdateDesignation(DesignationBO designationBO) { DeptDesigAndFinInstitutionDAS deptDesigAndFinInstitutionDAS = new DeptDesigAndFinInstitutionDAS(); int numberOfRowImpacted = 0; numberOfRowImpacted = deptDesigAndFinInstitutionDAS.UpdateDesignation(designationBO); return(numberOfRowImpacted > 0); }
/// <summary> /// To Update details of Designation in tbl_Designation_M table /// Created By : Darshan, 09/15/2014 /// Modified By : /// </summary> /// <param name="objDesignationBO"></param> /// <returns></returns> public ApplicationResult Designation_Update(DesignationBO objDesignationBO) { try { pSqlParameter = new SqlParameter[6]; pSqlParameter[0] = new SqlParameter("@DesignationID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objDesignationBO.DesignationID; pSqlParameter[1] = new SqlParameter("@DesignationNameENG", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objDesignationBO.DesignationNameENG; pSqlParameter[2] = new SqlParameter("@DesignationNameGUJ", SqlDbType.NVarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objDesignationBO.DesignationNameGUJ; pSqlParameter[3] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objDesignationBO.Description; pSqlParameter[4] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objDesignationBO.LastModifiedUserID; pSqlParameter[5] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objDesignationBO.LastModifiedDate; sSql = "usp_tbl_Designation_M_Update"; int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objDesignationBO = null; } }
private bool DeleteAction() { bool result = false; switch (this.SelectedTypeCode) { case "DT": DepartmentBO department = new DepartmentBO(); department.DepartmentCD = this.RequestCode; result = DeptDesigAndFinInstitutionBusController.RemoveDepartment(department); if (result) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Department Deleted Successfully')", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Department Not Deleted. Some Problem Occurred')", true); } this.SelectedTypeCode = null; break; case "DS": DesignationBO designation = new DesignationBO(); designation.DesignationCD = this.RequestCode; result = DeptDesigAndFinInstitutionBusController.RemoveDesignation(designation); if (result) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Deleted Successfully')", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Not Deleted. Some Problem Occurred')", true); } this.SelectedTypeCode = null; break; case "FI": FinancialInstitutionBO financialInstitution = new FinancialInstitutionBO(); financialInstitution.FinancialInstitutionCD = this.RequestCode; result = DeptDesigAndFinInstitutionBusController.RemoveFinancialInstitution(financialInstitution); if (result) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Financial Institution Deleted Successfully')", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Financial Institution Not Deleted. Some Problem Occurred')", true); } this.SelectedTypeCode = null; break; default: ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Bad Request.')", true); break; } return(result); }
public static DesignationBO GetDesignationBO(DesignationBO designationBO) { DeptDesigAndFinInstitutionDAS deptDesigAndFinInstitutionDAS = new DeptDesigAndFinInstitutionDAS(); string jsondata = deptDesigAndFinInstitutionDAS.GetDesignation(designationBO); List <DesignationBO> designationBOs; if (!jsondata.StartsWith("DB_ERROR")) { designationBOs = StringUtil.DeserializeObjectFromJSON <List <DesignationBO> >(jsondata); designationBO = designationBOs.ElementAt(0); } return(designationBO); }
public static bool IsDesignationPresent(DesignationBO designation) { DeptDesigAndFinInstitutionDAS deptDesigAndFinInstitutionDAS = new DeptDesigAndFinInstitutionDAS(); string jsondata = deptDesigAndFinInstitutionDAS.GetDesignation(designation); if (!jsondata.StartsWith("DB_ERROR")) { return(true); } else { return(false); } }
private void EditAction() { string postbackurl = ResourceTable("PageURL"); switch (this.SelectedTypeCode) { case "DT": DepartmentBO department = new DepartmentBO(); department.DepartmentCD = this.RequestCode; department = DeptDesigAndFinInstitutionBusController.GetDepartmentBO(department); lbl_Dept_title.Text = ResourceTable("EditDept"); this.txtDeptName.Text = department.DepartmentName; this.txtBankAcc.Text = department.DepartmentBankAccount; postbackurl += "?CD=" + StringUtil.Encode(department.DepartmentCD); this.btnAddDept.PostBackUrl = postbackurl; this.btnAddDept.Text = ResourceTable("StringUpdate"); break; case "DS": DesignationBO designation = new DesignationBO(); designation.DesignationCD = this.RequestCode; designation = DeptDesigAndFinInstitutionBusController.GetDesignationBO(designation); lbl_Desig_title.Text = ResourceTable("EditDesig"); this.txtDesigName.Text = designation.DesignationName; postbackurl += "?CD=" + StringUtil.Encode(designation.DesignationCD); this.btnDesigAdd.PostBackUrl = postbackurl; this.btnDesigAdd.Text = ResourceTable("StringUpdate"); break; case "FI": FinancialInstitutionBO financialInstitution = new FinancialInstitutionBO(); financialInstitution.FinancialInstitutionCD = this.RequestCode; financialInstitution = DeptDesigAndFinInstitutionBusController.GetFinancialInstitutionBO(financialInstitution); lbl_Fin_title.Text = ResourceTable("EditFin"); this.txtFinInstName.Text = financialInstitution.FinancialInstitutionName; this.txtFinInstAddress.Text = financialInstitution.FinancialInstitutionAddress; postbackurl += "?CD=" + StringUtil.Encode(financialInstitution.FinancialInstitutionCD); this.btnFinInstAdd.PostBackUrl = postbackurl; this.btnFinInstAdd.Text = ResourceTable("StringUpdate"); break; default: ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Bad Request.')", true); break; } }
protected void btnDesigAdd_Click(object sender, EventArgs e) { DesignationBO designation = new DesignationBO(); if (this.RequestCode != null) { designation.DesignationCD = this.RequestCode; if (DeptDesigAndFinInstitutionBusController.IsDesignationPresent(designation)) { designation.DesignationName = txtDesigName.Text; bool result = DeptDesigAndFinInstitutionBusController.UpdateDesignation(designation); if (result) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Updated Successfully')", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Not Updated. Some Problem Occurred')", true); } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Bad Request.')", true); } } else { designation.DesignationName = txtDesigName.Text; bool result = DeptDesigAndFinInstitutionBusController.AddDesignaion(designation); if (result) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Added Successfully')", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Not Added. Some Problem Occurred')", true); } } this.SelectedTypeCode = null; ShowDiv(); }
protected void btnSaveClass_OnClick(object sender, EventArgs e) { try { DesignationBO objDesignationBO = new DesignationBO(); DesignationBL objDesignationBL = new DesignationBL(); ApplicationResult objResult = new ApplicationResult(); DataTable dtResult = new DataTable(); int intDesignationID = 0; objDesignationBO.DesignationNameENG = txtDesignationNameENG.Text.Trim(); objDesignationBO.DesignationNameGUJ = txtDesignationNameGUJ.Text.Trim(); objDesignationBO.Description = txtDescription.Text.Trim(); objDesignationBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objDesignationBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); //Code For Validate Designation Name if (ViewState["Mode"].ToString() == "Save") { intDesignationID = -1; } else if (ViewState["Mode"].ToString() == "Edit") { intDesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString()); } objResult = objDesignationBL.Designation_ValidateName(intDesignationID, objDesignationBO.DesignationNameENG); if (objResult != null) { dtResult = objResult.resultDT; if (dtResult.Rows.Count > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Designation name already exist.');</script>"); } else { if (ViewState["Mode"].ToString() == "Save") { objDesignationBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objDesignationBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objResult = objDesignationBL.Designation_Insert(objDesignationBO); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { objDesignationBO.DesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString()); objResult = objDesignationBL.Designation_Update(objDesignationBO); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>"); } } ClearAll(); BindDesignation(); PanelVisibility(1); } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
public int Put([FromBody] DesignationBO value) { return(_iDesignationBL.UpdateDesignation(value)); }
// POST api/values public int Post([FromBody] DesignationBO value) { return(_iDesignationBL.AddDesignation(value)); }