public IActionResult addWithTrans([FromBody] VendorBalance model)
{
var result = new VendorTransaction();
result.IsActive = true;
result.IsPaidByPistis = true;
result.TransactionDate = DateTime.Now;
result.TransactionNumber = model.Transno;
result.VendorId = model.VendorId;
result.AmountPaid = Convert.ToDecimal(model.Payment);
db.VendorTransaction.Add(result);
try
{
db.SaveChanges();
var sum = db.VendorTransactionSummary.Where(x => x.IsActive == true && x.VendorId == model.VendorId).FirstOrDefault();
if (sum != null)
{
var pending = Convert.ToDecimal(sum.DueAmount - model.Payment);
sum.DueAmount = pending;
sum.ModifyOn = DateTime.Now;
db.Entry(sum).State = EntityState.Modified;
db.SaveChanges();
}
return(Ok(true));
}
catch (Exception ex)
{
return(Ok(false));
}
}
/// <summary>
/// Mapping model vendor transaction.
/// </summary>
/// <param name="master">The vendor transaction from brb util.</param>
/// <param name="transaction">The vendor transaction from spe database.</param>
/// <returns></returns>
private VendorTransaction MappingVendorTransaction(SPE_TRANSAC_PO_QA master, VendorTransaction transaction)
{
int id = transaction.Id;
string weightingKey = transaction.MarkWeightingKey;
transaction = _mapper.Map <SPE_TRANSAC_PO_QA, VendorTransaction>(master, transaction);
transaction.Id = id;
transaction.MarkWeightingKey = weightingKey;
transaction.ElasticStatus = ConstantValue.ElasticStatusUpdate;
return(transaction);
}
protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (Request.QueryString["brn"] != null)
{
Session[Constant.SESSION_BIDREFNO] = Request.QueryString["brn"].ToString();
}
if (!(Page.IsPostBack))
{
if (Request.QueryString[Constant.SESSION_BIDREFNO] != null)
{
Session[Constant.SESSION_BIDREFNO] = Request.QueryString[Constant.SESSION_BIDREFNO].ToString().Trim();
}
if (Session["ORDERBY"] == null)
{
Session["ORDERBY"] = "DESC";
}
BidItem bid = BidItemTransaction.QueryBidItemInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString());
BuyerTransaction buyer = new BuyerTransaction();
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
VendorTransaction vnd = new VendorTransaction();
IncotermTransaction inc = new IncotermTransaction();
OtherTransaction obj = new OtherTransaction();
lblBidReferenceNumber.Text = bid.BidRefNo.ToString().Trim();
lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
lblRequestor.Text = bid.Requestor.ToString().Trim();
lblPRNumber.Text = bid.PRRefNo.ToString().Trim();
lblPRDate.Text = bid.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim());
lblBidRefNo.Text = bid.BidRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim());
lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim();
lblBidItemDesc.Text = bid.ItemDescription.ToString().Trim();
lblDeliverTo.Text = bid.DeliverTo.ToString().Trim();
lblIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim());
DisplayDetails();
Bind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(Page.IsPostBack))
{
Session[Constant.SESSION_COMMENT_TYPE] = "0";
if (Request.QueryString["BidRefNo"] != null)
{
Session["BidRefNo"] = Request.QueryString["BidRefNo"].ToString().Trim();
}
BidItem bid = BidItemTransaction.QueryBidItemInfo(connstring, Request.QueryString["BidRefNo"].ToString().Trim());
BuyerTransaction buyer = new BuyerTransaction();
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
VendorTransaction vnd = new VendorTransaction();
IncotermTransaction inc = new IncotermTransaction();
OtherTransaction obj = new OtherTransaction();
lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
lblRequestor.Text = bid.Requestor.ToString().Trim();
lblPRNumber.Text = bid.PRRefNo.ToString().Trim();
lblPRDate.Text = bid.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim());
lblBidRefNo.Text = bid.BidRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim());
lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim();
lblBidItemDesc.Text = bid.ItemDescription.ToString().Trim();
lblDeliverTo.Text = bid.DeliverTo.ToString().Trim();
lblIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim());
DataTable dtSuppliers = BidItemTransaction.GetSuppliers(connstring, Session["BidRefNo"].ToString().Trim());
gvSuppliers.DataSource = dtSuppliers;
gvSuppliers.DataBind();
DataTable dtFileAttachment = new DataTable();
DataColumn dcol1 = new DataColumn("FILES", typeof(System.String));
dtFileAttachment.Columns.Add(dcol1);
string Files = bid.FileAttachments;
string[] Files1 = Files.Split(Convert.ToChar("|"));
for (int i = 0; i < Files1.Length; i++)
{
//Create a new row
DataRow drow = dtFileAttachment.NewRow();
drow["FILES"] = Files1[i];
dtFileAttachment.Rows.Add(drow);
}
gvFileAttachments.DataSource = dtFileAttachment;
gvFileAttachments.DataBind();
}
}
