public static bool saveDonationPurchases(ATTInvDonationsPurchases obj) { try { return(DLLInvDonationsPurchases.saveDonationPurchases(obj)); } catch (Exception ex) { throw ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { ATTInvDonationsPurchases objDonPur = new ATTInvDonationsPurchases(); objDonPur.OrgID = User.OrgID; objDonPur.ItemsCategoryID = int.Parse(DDLItemsCategory_Rqd.SelectedValue); objDonPur.ItemsSubCategoryID = int.Parse(DDLItemsSubCategory_Rqd.SelectedValue); objDonPur.ItemsID = int.Parse(DDLItems_Rqd.SelectedValue); objDonPur.DonationPurchaseDate = txtDonationPurchaseDate_RDT.Text; objDonPur.DonationPurchaseSeq = null; objDonPur.DonationPurchaseType = chkDonation.Checked ? "D" : "P"; objDonPur.DonationPurchaseOrg = txtOrganization_Rqd.Text; objDonPur.DonationPurchaseQty = int.Parse(txtQuantity_Rqd.Text); if (chkDonation.Checked) { objDonPur.DonationPurchaseUnitPrice = 0; } else { if (txtPrice.Text == "") { this.lblStatusMessage.Text = "Enter price"; this.programmaticModalPopup.Show(); return; } else { objDonPur.DonationPurchaseUnitPrice = int.Parse(txtPrice.Text); } } objDonPur.ReceivedBy = int.Parse(txtEmpID.Text); objDonPur.ReceivedDate = txtReceivedDate_RDT.Text; objDonPur.EntrBy = User.UserName; objDonPur.Action = "A"; BLLInvDonationsPurchases.saveDonationPurchases(objDonPur); this.lblStatusMessage.Text = "Donation Purchases Successfully saved"; this.programmaticModalPopup.Show(); ClearControls(0); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public static bool saveDonationPurchases(ATTInvDonationsPurchases obj) { List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":p_org_id ", obj.OrgID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_category_id", obj.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_sub_category_id", obj.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_id", obj.ItemsID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_date ", obj.DonationPurchaseDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_seq", obj.DonationPurchaseSeq, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_type", obj.DonationPurchaseType, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_org", obj.DonationPurchaseOrg, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_qty ", obj.DonationPurchaseQty, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_unit_price", obj.DonationPurchaseUnitPrice, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_rcvd_by", obj.ReceivedBy, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_rcvd_date", obj.ReceivedDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_entry_by ", obj.EntrBy, OracleDbType.Varchar2, ParameterDirection.Input)); GetConnection getConn = new GetConnection(); try { OracleConnection DBConn = getConn.GetDbConn(Module.OAS); if (obj.Action == "A") //New Add { SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, "sp_inv_add_don_purchases", paramArray.ToArray()); } else if (obj.Action == "E") //Update { SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, "sp_inv_edit_don_purchases", paramArray.ToArray()); } obj.DonationPurchaseSeq = int.Parse(paramArray[5].Value.ToString()); return(true); } catch (Exception ex) { throw ex; } finally { getConn.CloseDbConn(); } }