/// <summary> /// to fetch details /// </summary> /// <returns></returns> public LivelihoodRestoreItemsList GetLiveRestItems_All() { proc = "USP_MST_GET_LIV_REST_ITEMS_ALL"; cnn = new OracleConnection(con); LivelihoodRestoreItemsBO oLiveRestItemsBO; LivelihoodRestoreItemsList lstLiveRestItems = new LivelihoodRestoreItemsList(); 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()) { oLiveRestItemsBO = new LivelihoodRestoreItemsBO(); lstLiveRestItems.Add(MapData(dr)); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstLiveRestItems); }
/// <summary> /// to update data /// </summary> /// <param name="oLiveRestItemsBO"></param> /// <returns></returns> public string UpdateLiveRestItem(LivelihoodRestoreItemsBO oLiveRestItemsBO) { string returnResult; cnn = new OracleConnection(con); proc = "USP_MST_UPD_LIV_REST_ITEMS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("Liv_Rest_ItemID_", oLiveRestItemsBO.Liv_Rest_ItemID); cmd.Parameters.Add("Liv_Rest_ItemName_", oLiveRestItemsBO.Liv_Rest_ItemName); //Common Parameters cmd.Parameters.Add("updatedby_", oLiveRestItemsBO.UpdatedBy); 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> /// to fetch details by ID /// </summary> /// <param name="RestorationItemID"></param> /// <returns></returns> public LivelihoodRestoreItemsBO GetLiveRestItemsById(int RestorationItemID) { proc = "USP_MST_GET_LIV_REST_ITEMSBYID"; cnn = new OracleConnection(con); LivelihoodRestoreItemsBO oLiveRestItemsBO = null; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Liv_Rest_ItemID_", RestorationItemID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { oLiveRestItemsBO = new LivelihoodRestoreItemsBO(); oLiveRestItemsBO = MapData(dr); } dr.Close(); } catch (Exception ex) { throw ex; } return(oLiveRestItemsBO); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { objLivelihoodRestoreItemsBLL = new LivelihoodRestoreItemsBLL(); objItem = new LivelihoodRestoreItemsBO(); grdItem.DataSource = objLivelihoodRestoreItemsBLL.GetLiveRestItems_All();//(objItem); grdItem.DataBind(); }
/// <summary> /// To fetch details from database and assign to textbox /// </summary> /// <param name="sender"></param> /// <param name="e"></param>e private void GetItemDetails() { objLivelihoodRestoreItemsBLL = new LivelihoodRestoreItemsBLL(); int ItemID = 0; if (ViewState["Liv_Rest_ItemID"] != null) { ItemID = Convert.ToInt32(ViewState["Liv_Rest_ItemID"].ToString()); } objItem = new LivelihoodRestoreItemsBO(); objItem = objLivelihoodRestoreItemsBLL.GetLiveRestItemsById(ItemID); txtItemName.Text = objItem.Liv_Rest_ItemName; }
/// <summary> /// to map data /// </summary> /// <param name="reader"></param> /// <returns></returns> private LivelihoodRestoreItemsBO MapData(IDataReader reader) { LivelihoodRestoreItemsBO oLiveRestItemsBO = new LivelihoodRestoreItemsBO(); if (ColumnExists(reader, "Liv_Rest_ItemID") && !reader.IsDBNull(reader.GetOrdinal("Liv_Rest_ItemID"))) { oLiveRestItemsBO.Liv_Rest_ItemID = reader.GetInt32(reader.GetOrdinal("Liv_Rest_ItemID")); } if (ColumnExists(reader, "Liv_Rest_ItemName") && !reader.IsDBNull(reader.GetOrdinal("Liv_Rest_ItemName"))) { oLiveRestItemsBO.Liv_Rest_ItemName = reader.GetString(reader.GetOrdinal("Liv_Rest_ItemName")); } if (ColumnExists(reader, "IsDeleted") && !reader.IsDBNull(reader.GetOrdinal("IsDeleted"))) { oLiveRestItemsBO.IsDeleted = reader.GetString(reader.GetOrdinal("IsDeleted")); } return(oLiveRestItemsBO); }
/// <summary> /// to fetch details /// </summary> /// <returns></returns> public LivelihoodRestoreItemsList GetLiveRestItems() { proc = "USP_MST_GET_LIV_REST_ITEMS"; cnn = new OracleConnection(con); LivelihoodRestoreItemsBO oLiveRestItemsBO; LivelihoodRestoreItemsList lstLiveRestItems = new LivelihoodRestoreItemsList(); 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()) { oLiveRestItemsBO = new LivelihoodRestoreItemsBO(); //if (!dr.IsDBNull(dr.GetOrdinal("Liv_Rest_ItemID"))) oLiveRestItemsBO.Liv_Rest_ItemID = dr.GetInt32(dr.GetOrdinal("Liv_Rest_ItemID")); //if (!dr.IsDBNull(dr.GetOrdinal("Liv_Rest_ItemName"))) oLiveRestItemsBO.Liv_Rest_ItemName = dr.GetString(dr.GetOrdinal("Liv_Rest_ItemName")); ////if (!dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) objBank.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); //lstLiveRestItems.Add(oLiveRestItemsBO); lstLiveRestItems.Add(MapData(dr)); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstLiveRestItems); }
/// <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; objItem = new LivelihoodRestoreItemsBO(); objLivelihoodRestoreItemsBLL = new LivelihoodRestoreItemsBLL(); //Assignement objItem.Liv_Rest_ItemName = txtItemName.Text.Trim(); if (ViewState["Liv_Rest_ItemID"] != null) { objItem.Liv_Rest_ItemID = Convert.ToInt32(ViewState["Liv_Rest_ItemID"].ToString()); } objItem.IsDeleted = "False"; if (Session["USER_ID"] != null) { objItem.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); } if (objItem.Liv_Rest_ItemID < 1) { //If ItemID does Not exists then SaveItem objItem.Liv_Rest_ItemID = -1;//For New Item message = objLivelihoodRestoreItemsBLL.AddLiveRestItem(objItem); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearDetails(); BindGrid(true, false); } } else { if (Session["USER_ID"] != null) { objItem.UpdatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); } //If ItemID exists then UpdateItem message = objLivelihoodRestoreItemsBLL.UpdateLiveRestItem(objItem); //For Updating Item if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; ClearDetails(); BindGrid(true, false); } } if (message != "") { AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); } SetUpdateMode(false); }
/// <summary> /// To Update Live Rest Item /// </summary> /// <param name="oLiveRestItemsBO"></param> /// <returns></returns> public string UpdateLiveRestItem(LivelihoodRestoreItemsBO oLiveRestItemsBO) { return((new LivelihoodRestoreItemsDAL()).UpdateLiveRestItem(oLiveRestItemsBO)); }