/// <summary> /// To Get Literacy Status /// </summary> /// <returns></returns> public LiteracyStatusList GetLiteracyStatus() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GETLITERACYSTATUS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LiteracyStatusBO LiteracyStatusBOobj = null; LiteracyStatusList LiteracyStatusListobj = new LiteracyStatusList(); while (dr.Read()) { LiteracyStatusBOobj = new LiteracyStatusBO(); if (!dr.IsDBNull(dr.GetOrdinal("LTR_STATUSID"))) { LiteracyStatusBOobj.LTR_STATUSID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LTR_STATUSID"))); } if (!dr.IsDBNull(dr.GetOrdinal("LTR_STATUS"))) { LiteracyStatusBOobj.LTR_STATUS = dr.GetString(dr.GetOrdinal("LTR_STATUS")); } LiteracyStatusListobj.Add(LiteracyStatusBOobj); } dr.Close(); return(LiteracyStatusListobj); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private string InsertLitStatusDetail() { string message = string.Empty; string uID = Session["USER_ID"].ToString(); LitStatusBoobj = new LiteracyStatusBO(); //Assignement of Data LitStatusBoobj.LTR_STATUS = txtLiteracyStatus.Text.Trim(); LitStatusBoobj.DESCRIPTION = txtDescription.Text.Trim(); LitStatusBoobj.ISDELETED = "False"; LitStatusBoobj.CREATEDBY = Convert.ToInt32(uID);//By Default Admin LitStatusBoobj.CREATEDDATE = DateTime.Now; LiteracyStatusBLL LitStatusBLL = new LiteracyStatusBLL(); try { message = LitStatusBLL.Insert(LitStatusBoobj); } catch (Exception ee) { throw ee; } finally { LitStatusBLL = null; } return(message); // BindGrid(true, true); // ClearDetails(); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('LiteracyStatus details added successfully');", true); }
/// <summary> /// To call insert method /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; LiteracyStatusBLL LiteracyStatusBLLobj = null; try { if (btnSave.Text == "Save") { message = InsertLitStatusDetail(); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearDetails(); } BindGrid(true, true); } else { int litStatusID = Convert.ToInt32(ViewState["LitStatusID"]); LitStatusBoobj = new LiteracyStatusBO(); LitStatusBoobj.LTR_STATUS = txtLiteracyStatus.Text.ToString(); LitStatusBoobj.DESCRIPTION = txtDescription.Text.ToString(); LitStatusBoobj.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); LiteracyStatusBLLobj = new LiteracyStatusBLL(); message = LiteracyStatusBLLobj.Update(LitStatusBoobj, litStatusID); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } btnSave.Text = "Save"; ClearDetails(); SetUpdateMode(false); } catch (Exception ee) { throw ee; } finally { LiteracyStatusBLLobj = null; } BindGrid(true, false); AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }
/// <summary> /// TO Update in Database /// </summary> /// <param name="LitStatusBoobj"></param> /// <param name="litStatusID"></param> /// <returns></returns> public string Update(LiteracyStatusBO LitStatusBoobj, int litStatusID) { LiteracyStatusDAL LiteracyStatusDALobj = new LiteracyStatusDAL(); //Data pass -to Database Layer try { return(LiteracyStatusDALobj.Update(LitStatusBoobj, litStatusID)); } catch (Exception ex) { throw ex; } finally { LiteracyStatusDALobj = null; } }
/// <summary> /// To Insert into Database /// </summary> /// <param name="LiteracyStatusBOobj"></param> /// <returns></returns> public string Insert(LiteracyStatusBO LiteracyStatusBOobj) { LiteracyStatusDAL LiteracyStatusDAL = new LiteracyStatusDAL(); //Data pass -to Database Layer try { return(LiteracyStatusDAL.Insert(LiteracyStatusBOobj)); } catch (Exception ex) { throw ex; } finally { LiteracyStatusDAL = null; } }
/// <summary> /// To Insert into Database /// </summary> /// <param name="LiteracyStatusBoobj"></param> /// <returns></returns> public string Insert(LiteracyStatusBO LiteracyStatusBoobj) { string returnResult = string.Empty; OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); con.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_INSERTLITERACYSTATUS", con); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("LTR_STATUS", LiteracyStatusBoobj.LTR_STATUS); dcmd.Parameters.Add("DESCRIPTION", LiteracyStatusBoobj.DESCRIPTION); dcmd.Parameters.Add("createdby", LiteracyStatusBoobj.CREATEDBY); //return dcmd.ExecuteNonQuery(); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { returnResult = dcmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } } catch (Exception ex) { throw ex;; } finally { dcmd.Dispose(); con.Close(); con.Dispose(); } return(returnResult); }
/// <summary> /// To Update /// </summary> /// <param name="LitStatusBoobj"></param> /// <param name="litStatusID"></param> /// <returns></returns> public string Update(LiteracyStatusBO LitStatusBoobj, int litStatusID) { string returnResult = string.Empty; OracleConnection conn = new OracleConnection(AppConfiguration.ConnectionString); conn.Open(); OracleCommand dCmd = new OracleCommand("USP_MST_UPDATELITERACYSTATUS", conn); dCmd.CommandType = CommandType.StoredProcedure; try { dCmd.Parameters.Add("L_LTR_STATUSID", litStatusID); dCmd.Parameters.Add("L_LTR_STATUS", LitStatusBoobj.LTR_STATUS); dCmd.Parameters.Add("L_DESCRIPTION", LitStatusBoobj.DESCRIPTION); dCmd.Parameters.Add("L_CREATEDBY", LitStatusBoobj.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(); } else { returnResult = string.Empty; } //return dCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { dCmd.Dispose(); conn.Close(); conn.Dispose(); } return(returnResult); }