/// <summary> /// To Update Structure Category /// </summary> /// <param name="oStructureCategory"></param> /// <returns></returns> public string UpdateStructureCategory(StructureCategoryBO oStructureCategory) { string returnResult; cnn = new OracleConnection(con); proc = "USP_MST_UPD_STRUCTCATEGORY"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("str_categoryid_", oStructureCategory.StructureCategoryID); cmd.Parameters.Add("str_categoryname_", oStructureCategory.StructureCategoryName); cmd.Parameters.Add("updatedby_", oStructureCategory.UserID); cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); if (cmd.Parameters["errorMessage_"].Value != null) { returnResult = cmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } return(returnResult); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { objStructureCategoryBLL = new StructureCategoryBLL(); objStructureCategory = new StructureCategoryBO(); objStructureCategory.StructureCategoryName = string.Empty; objStructureCategory.StructureCategoryID = 0; grdStructureCategory.DataSource = objStructureCategoryBLL.GetAllStructureCategory(); grdStructureCategory.DataBind(); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string message = string.Empty; string AlertMessage = string.Empty; objStructureCategory = new StructureCategoryBO(); objStructureCategoryBLL = new StructureCategoryBLL(); //Assignement objStructureCategory.StructureCategoryName = txtStructureCategory.Text.Trim(); if (ViewState["StructureCategoryID"] != null) { objStructureCategory.StructureCategoryID = Convert.ToInt32(ViewState["StructureCategoryID"].ToString()); } objStructureCategory.IsDeleted = "False"; //if (Session["USER_ID"] != null) objStructureCategory.UserID = Convert.ToInt32(Session["USER_ID"].ToString()); if (objStructureCategory.StructureCategoryID < 1) { //If StructureCategoryID does Not exists then SaveStructureCategory objStructureCategory.StructureCategoryID = -1;//For New StructureCategory message = objStructureCategoryBLL.AddStructureCategory(objStructureCategory); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully."; ClearDetails(); BindGrid(true, false); } //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Structure Category Added Successfully!!');", true); } else { //If StructureCategoryID exists then UpdateStructureCategory message = objStructureCategoryBLL.UpdateStructureCategory(objStructureCategory); //For Updating StructureCategory if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully."; ClearDetails(); BindGrid(true, false); } //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('Structure Category updated successfully!!');", true); } //ClearDetails(); AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); SetUpdateMode(false); }
/// <summary> /// To fetch data from database and assign to textbox /// </summary> private void GetStructureCategoryDetails() { objStructureCategoryBLL = new StructureCategoryBLL(); int StructureCategoryID = 0; if (ViewState["StructureCategoryID"] != null) { StructureCategoryID = Convert.ToInt32(ViewState["StructureCategoryID"].ToString()); } objStructureCategory = new StructureCategoryBO(); objStructureCategory = objStructureCategoryBLL.GetStructureCategoryById(StructureCategoryID); txtStructureCategory.Text = objStructureCategory.StructureCategoryName; }
/// <summary> /// To Get All Structure Category /// </summary> /// <returns></returns> public StructureCategoryList GetAllStructureCategory() { proc = "USP_MST_GET_ALL_STRUCTCATEGORY"; cnn = new OracleConnection(con); StructureCategoryBO objStructureCategory = null; StructureCategoryList lstStructureCategoryList = new StructureCategoryList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objStructureCategory = new StructureCategoryBO(); if (ColumnExists(dr, "str_categoryid") && !dr.IsDBNull(dr.GetOrdinal("str_categoryid"))) { objStructureCategory.StructureCategoryID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("str_categoryid"))); } if (ColumnExists(dr, "str_categoryname") && !dr.IsDBNull(dr.GetOrdinal("str_categoryname"))) { objStructureCategory.StructureCategoryName = dr.GetString(dr.GetOrdinal("str_categoryname")); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { objStructureCategory.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } lstStructureCategoryList.Add(objStructureCategory); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstStructureCategoryList); }
/// <summary> /// To Get Structure Category By Id /// </summary> /// <param name="StructureCategoryID"></param> /// <returns></returns> public StructureCategoryBO GetStructureCategoryById(int StructureCategoryID) { cnn = new OracleConnection(con); proc = "USP_MST_GET_STRUCTCATEGORYBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("str_categoryid_", StructureCategoryID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); StructureCategoryBO objStructureCategory = null; while (dr.Read()) { objStructureCategory = new StructureCategoryBO(); if (ColumnExists(dr, "str_categoryid") && !dr.IsDBNull(dr.GetOrdinal("str_categoryid"))) { objStructureCategory.StructureCategoryID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("str_categoryid"))); } if (ColumnExists(dr, "str_categoryname") && !dr.IsDBNull(dr.GetOrdinal("str_categoryname"))) { objStructureCategory.StructureCategoryName = dr.GetString(dr.GetOrdinal("str_categoryname")); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { objStructureCategory.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } } dr.Close(); return(objStructureCategory); }
/// <summary> /// To Update Structure Category /// </summary> /// <param name="oStructureCategory"></param> /// <returns></returns> public string UpdateStructureCategory(StructureCategoryBO oStructureCategory) { objStructureCategoryDAL = new StructureCategoryDAL(); return(objStructureCategoryDAL.UpdateStructureCategory(oStructureCategory)); }
/// <summary> /// To Add Structure Category /// </summary> /// <param name="oStructureCategory"></param> /// <returns></returns> public string AddStructureCategory(StructureCategoryBO oStructureCategory) { objStructureCategoryDAL = new StructureCategoryDAL(); return(objStructureCategoryDAL.SaveStructureCategory(oStructureCategory)); }