/// <summary> /// to fetch all details /// </summary> /// <returns></returns> public GrievancesMasterList GetALLGrievancesCategory() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETALL_GRIVCATEGORY"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); GrievancesMasterBO objTypeBO = null; GrievancesMasterList objGrievancesCategorys = new GrievancesMasterList(); while (dr.Read()) { objTypeBO = new GrievancesMasterBO(); objTypeBO.GRIEVANCECATEGID = dr.GetInt32(dr.GetOrdinal("GRIEVANCECATEGID")); objTypeBO.GrievancesCategory = dr.GetString(dr.GetOrdinal("GRIEVANCECATEGORY")); objTypeBO.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted")); objGrievancesCategorys.Add(objTypeBO); } dr.Close(); return(objGrievancesCategorys); }
/// <summary> /// to fetch all details /// </summary> /// <param name="GRIEVANCECATEGID"></param> /// <returns></returns> public GrievancesMasterBO GetGrievancesCategoryId(int GRIEVANCECATEGID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_GRIVCATEGORYBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("GRIEVANCECATEGID_", GRIEVANCECATEGID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); GrievancesMasterBO objconsultantType = null; GrievancesMasterList Users = new GrievancesMasterList(); objconsultantType = new GrievancesMasterBO(); while (dr.Read()) { if (ColumnExists(dr, "GRIEVANCECATEGORY") && !dr.IsDBNull(dr.GetOrdinal("GRIEVANCECATEGORY"))) { objconsultantType.GrievancesCategory = dr.GetString(dr.GetOrdinal("GRIEVANCECATEGORY")); } if (ColumnExists(dr, "GRIEVANCECATEGID") && !dr.IsDBNull(dr.GetOrdinal("GRIEVANCECATEGID"))) { objconsultantType.GRIEVANCECATEGID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("GRIEVANCECATEGID"))); } } dr.Close(); return(objconsultantType); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string message = ""; GrievancesMasterBLL GrievancesMasterBLLobj = null; try { GrievancesMasterBLLobj = new GrievancesMasterBLL(); GrievancesMasterBO objGrievancesMaster = new GrievancesMasterBO(); if (Convert.ToInt32(ViewState["GRIEVANCECATEGID"]) > 0) { objGrievancesMaster.GrievancesCategory = txtGrievancesCategory.Text.Trim(); objGrievancesMaster.GRIEVANCECATEGID = Convert.ToInt32(ViewState["GRIEVANCECATEGID"]); message = GrievancesMasterBLLobj.EDITGrievancesCategory(objGrievancesMaster); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } SetUpdateMode(false); } else { objGrievancesMaster.GrievancesCategory = txtGrievancesCategory.Text.Trim(); objGrievancesMaster.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = GrievancesMasterBLLobj.insert(objGrievancesMaster); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } clearfields(); BindGrid(true, true); } catch (Exception ex) { throw ex; } finally { GrievancesMasterBLLobj = null; } }
/// <summary> /// get the Grid value into textBox /// </summary> private void GetGrievancesCategoryDetails() { GrievancesMasterBLL GrievancesMasterBLLobj = new GrievancesMasterBLL(); int GRIEVANCECATEGID = 0; if (ViewState["GRIEVANCECATEGID"] != null) { GRIEVANCECATEGID = Convert.ToInt32(ViewState["GRIEVANCECATEGID"]); } GrievancesMasterBO objGrievancesMaster = new GrievancesMasterBO(); objGrievancesMaster = GrievancesMasterBLLobj.GetGrievancesCategoryId(GRIEVANCECATEGID); txtGrievancesCategory.Text = objGrievancesMaster.GrievancesCategory; }
/// <summary> /// To EDIT Grievances Category /// </summary> /// <param name="objconsultantType"></param> /// <returns></returns> public string EDITGrievancesCategory(GrievancesMasterBO objconsultantType) { GrievancesMasterDAL GrievancesMasterDALobj = new GrievancesMasterDAL(); //Data pass -to Database Layer try { return(GrievancesMasterDALobj.EDITGrievancesCategory(objconsultantType)); } catch { throw; } finally { GrievancesMasterDALobj = null; } }
/// <summary> /// to update data /// </summary> /// <param name="objconsultantType"></param> /// <returns></returns> public string EDITGrievancesCategory(GrievancesMasterBO objconsultantType) { string returnResult = ""; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPD_GRIEVANCECATEGORY", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("GRIEVANCECATEGID_", objconsultantType.GRIEVANCECATEGID); dcmd.Parameters.Add("GRIEVANCECATEGORY_", objconsultantType.GrievancesCategory); dcmd.Parameters.Add("UpdatedBY", objconsultantType.CreatedBy); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { returnResult = dcmd.Parameters["errorMessage_"].Value.ToString(); } return(returnResult); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } }