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();
}
}
