private CreditorInvoice ExtractData()
{
var est = new CreditorInvoice
{
CreditorInvoiceId = CreInvoiceId,
CreditorId = Convert.ToInt32(ddlCreditorName.SelectedValue),
PartyTypeID = Convert.ToInt32(ddlPartyType.SelectedValue),
CreInvoiceNo = txtCreInvoiceNo.Text,
OurInvoiceRef = lblOurInvoiceRef.Text,
//HouseBLNo = lblHouseBLNo.Text,
Location = lblLocation.Text,
CreditorInvoiceCharges = (List <CreditorInvoiceCharge>)ViewState["Charges"],
ReferenceDate = Convert.ToDateTime(txtReferenceDate.Text),
CompanyID = 1,
InvoiceAmount = Convert.ToDouble(lblInvoiceAmount.Text),
RoundingOff = Convert.ToDouble(txtRoff.Text),
UserID = _userId,
CreInvoiceDate = Convert.ToDateTime(txtCreInvoiceDate.Text),
JobNumber = JobID,
approved = Convert.ToInt32(Convert.ToInt32(rdbApproval.SelectedItem.Value)),
//approved = chkApproved.Checked,
comment = txtComment.Text
};
return(est);
}
public static int SaveCreditorInvoice(CreditorInvoice creditorInvoice, string Mode)
{
string strExecution = "[fwd].[uspManageCreInv]";
int result = 0;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddVarcharParam("@Mode", 1, Mode);
oDq.AddIntegerParam("@pk_CinvoiceID", creditorInvoice.CreditorInvoiceId);
oDq.AddIntegerParam("@fk_CompanyID", creditorInvoice.CompanyID);
oDq.AddIntegerParam("@fk_JobID", Convert.ToInt32(creditorInvoice.JobNumber));
oDq.AddIntegerParam("@fk_CreditorID", creditorInvoice.CreditorId);
oDq.AddIntegerParam("@fk_PartyTypeID", creditorInvoice.PartyTypeID);
oDq.AddVarcharParam("@InvoiceNo", 60, creditorInvoice.CreInvoiceNo);
oDq.AddDateTimeParam("@InvoiceDate", creditorInvoice.CreInvoiceDate);
oDq.AddVarcharParam("@BLARefNo", 30, creditorInvoice.OurInvoiceRef);
oDq.AddDateTimeParam("@BLARefDate", creditorInvoice.ReferenceDate);
var charge = creditorInvoice.CreditorInvoiceCharges.FirstOrDefault();
oDq.AddIntegerParam("@fk_CurrencyID", charge.CurrencyId);
oDq.AddDecimalParam("@ROE", 12, 3, Convert.ToDecimal(charge.ConvRate));
oDq.AddDecimalParam("@Roff", 6, 2, Convert.ToDecimal(creditorInvoice.RoundingOff));
oDq.AddBooleanParam("@CreInvActive", true);
oDq.AddIntegerParam("@Approved", Convert.ToInt32(creditorInvoice.approved));
oDq.AddVarcharParam("@Comment", 300, creditorInvoice.comment);
oDq.AddVarcharParam("@Charges", int.MaxValue, Utilities.GeneralFunctions.SerializeWithXmlTag(creditorInvoice.CreditorInvoiceCharges).Replace("?<?xml version=\"1.0\" encoding=\"utf-16\"?>", ""));
oDq.AddIntegerParam("@UserID", creditorInvoice.UserID);
oDq.AddIntegerParam("@Result", result, QueryParameterDirection.Output);
var pk_AdvAdjInvID = Convert.ToInt32(oDq.GetScalar());
result = Convert.ToInt32(oDq.GetParaValue("@Result"));
}
return(result);
}
public int SaveCreditorInvoice(CreditorInvoice creditorInvoice, string Mode)
{
return(CreditorInvoiceDAL.SaveCreditorInvoice(creditorInvoice, Mode));
}
