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