/// <summary> /// To GET ALL LivPlanItem /// </summary> /// <returns></returns> public LivPlanItemList GETALLLivPlanItem() { // used in Master page OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GETALLLivPlanItem"; 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); LivPlanItemBO objLivPlanItem = null; LivPlanItemList LivPlanItem = new LivPlanItemList(); while (dr.Read()) { objLivPlanItem = new LivPlanItemBO(); objLivPlanItem.LivPlanItemID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LIV_REST_ITEMID"))); objLivPlanItem.LivPlanItemName = dr.GetString(dr.GetOrdinal("LIV_REST_ITEMNAME")); objLivPlanItem.Isdeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); LivPlanItem.Add(objLivPlanItem); } dr.Close(); return(LivPlanItem); }
/// <summary> /// get the data based on ID /// </summary> /// <param name="LivPlanItemID"></param> /// <returns></returns> public LivPlanItemBO GetLivPlanItemById(int LivPlanItemID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSELECTLivPlanItem"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("LivPlanItemID_", LivPlanItemID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LivPlanItemBO LivPlanItemObj = null; LivPlanItemList Users = new LivPlanItemList(); LivPlanItemObj = new LivPlanItemBO(); while (dr.Read()) { if (ColumnExists(dr, "LIV_REST_ITEMNAME") && !dr.IsDBNull(dr.GetOrdinal("LIV_REST_ITEMNAME"))) { LivPlanItemObj.LivPlanItemName = dr.GetString(dr.GetOrdinal("LIV_REST_ITEMNAME")); } if (ColumnExists(dr, "LIV_REST_ITEMID") && !dr.IsDBNull(dr.GetOrdinal("LIV_REST_ITEMID"))) { LivPlanItemObj.LivPlanItemID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LIV_REST_ITEMID"))); } } dr.Close(); return(LivPlanItemObj); }
/// <summary> /// get the Grid value into textBox /// </summary> private void GetLivPlanItemDetails(int LivPlanItemID) { LivPlanItemBLL LivPlanItemBLLobj = new LivPlanItemBLL(); //int LivPlanItemID = 0; //if (ViewState["LivPlanItemID"] != null) // LivPlanItemID = Convert.ToInt32(ViewState["LivPlanItemID"]); LivPlanItemBO LivPlanItemObj = new LivPlanItemBO(); LivPlanItemObj = LivPlanItemBLLobj.GetLivPlanItemById(LivPlanItemID); LivPlanItemTextBox.Text = LivPlanItemObj.LivPlanItemName; LivPlanItemIDTextBox.Text = LivPlanItemObj.LivPlanItemID.ToString(); //int LivPlanItemID_test = Convert.ToInt32(LivPlanItemObj.LivPlanItemID); }
//Edit the data public string EDITLivPlanItem(LivPlanItemBO objLivPlanItem) { LivPlanItemDAL LivPlanItemDAl = new LivPlanItemDAL(); //Data pass -to Database Layer try { return(LivPlanItemDAl.EDITLivPlanItem(objLivPlanItem)); } catch { throw; } finally { LivPlanItemDAl = null; } }
/// <summary> /// To update data to database /// </summary> /// <param name="objLivPlanItem"></param> /// <returns></returns> public string EDITLivPlanItem(LivPlanItemBO objLivPlanItem) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATECLivPlanItem", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("LivPlanItem_", objLivPlanItem.LivPlanItemName); dcmd.Parameters.Add("LivPlanItemID_", objLivPlanItem.LivPlanItemID); dcmd.Parameters.Add("UpdatedBY", objLivPlanItem.UserID); //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 { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } return(returnResult); }
/// <summary> /// save data to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { // int count = 0; string AlertMessage = string.Empty; string message = string.Empty; if (LivPlanItemIDTextBox.Text.ToString().Trim() == string.Empty) { LivPlanItemBLL LivPlanItemBLLOBJ = new LivPlanItemBLL(); try { string uID = Session["USER_ID"].ToString(); LivPlanItemBO objLivPlanItem = new LivPlanItemBO(); objLivPlanItem.LivPlanItemName = LivPlanItemTextBox.Text.ToString().Trim();; objLivPlanItem.UserID = Convert.ToInt32(uID); LivPlanItemBLL LivPlanItemBLLobj = new LivPlanItemBLL(); message = LivPlanItemBLLobj.Insert(objLivPlanItem); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; clear(); // ClearDetails(); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { LivPlanItemBLLOBJ = null; } } //edit the data in the textbox exiting in the Grid else if (LivPlanItemIDTextBox.Text.ToString().Trim() != string.Empty) { LivPlanItemBLL LivPlanItemBLLOBJ = new LivPlanItemBLL(); try { string uID = Session["USER_ID"].ToString(); LivPlanItemBO objLivPlanItem = new LivPlanItemBO(); objLivPlanItem.LivPlanItemName = LivPlanItemTextBox.Text.ToString().Trim(); objLivPlanItem.LivPlanItemID = Convert.ToInt32(LivPlanItemIDTextBox.Text.ToString().Trim()); objLivPlanItem.UserID = Convert.ToInt32(uID); LivPlanItemBLL LivPlanItemBLLobj = new LivPlanItemBLL(); message = LivPlanItemBLLobj.EDITLivPlanItem(objLivPlanItem); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; // ClearDetails(); clear(); SetUpdateMode(false); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { LivPlanItemBLLOBJ = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }