internal static int saveAiaBilling(AIABilling modelBilling) { int result = -2; try { string spName = string.Empty; var id = (SqlHelper.ExecuteScalar(_myConnection, CommandType.StoredProcedure, "spATL_ADM_JobBillDtMain_AIA_Ins", new SqlParameter("@PRJID", modelBilling.PRJID), new SqlParameter("@CommissionExpires", modelBilling.CommissionExpires), new SqlParameter("@ApplicationNum", modelBilling.ApplicationNum), new SqlParameter("@BillingDate", modelBilling.BillingDate), new SqlParameter("@EntryDate", modelBilling.EntryDate), new SqlParameter("@NotaryDate", modelBilling.NotaryDate), new SqlParameter("@OriginalContractSum", modelBilling.OriginalContractSum), new SqlParameter("@NetChangeByCO", modelBilling.NetChangeByCO), new SqlParameter("@ItemNo", modelBilling.ItemNo), new SqlParameter("@QtyOfBI", modelBilling.QtyOfBI), new SqlParameter("@unitOfMeasure", modelBilling.UnitOfMeasure), new SqlParameter("@UnitPrice", modelBilling.UnitPrice), new SqlParameter("@BIDID", modelBilling.BIDID), new SqlParameter("@BilledQty", modelBilling.BilledQty), new SqlParameter("@Accecpt", modelBilling.Accept))); result = id == DBNull.Value ? 1 : result; } catch (Exception ex) { Logger.SaveErr(ex); } return(result); }
public JsonResult getAiaBilling(string PRJID, string BIDID) { AIABilling modelBilling = null; if (!string.IsNullOrWhiteSpace(PRJID) && !string.IsNullOrWhiteSpace(BIDID)) { modelBilling = AdminDal.getAIABilling(PRJID, BIDID); } return(Json(modelBilling)); }
public ActionResult saveAiabilling(AIABilling modelBilling) { int id = modelBilling.PRJID; try { modelBilling.NetChangeByCO = Convert.ToDecimal(modelBilling.NetChangeByCO); modelBilling.OriginalContractSum = Convert.ToDecimal(modelBilling.OriginalContractSum); modelBilling.UnitPrice = Convert.ToDecimal(modelBilling.UnitPrice).ToString(); if (ModelState.IsValid) { if (!string.IsNullOrWhiteSpace(Convert.ToString(modelBilling.PRJID)) && Convert.ToInt32(modelBilling.PRJID) > 0) { var ResultId = AdminDal.saveAiaBilling(modelBilling); if (ResultId > 0) { return(RedirectToAction("billing", "admin")); } else { ViewBag.UOMTypes = new SelectList(Atlas.DataAccess.Entity.Common.getUnitofMeasure(), "UnitOfMeasure", "UomDescription"); //ar BidItems = ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)).Select(i=>i.BidItemId); ViewBag.BidItems = new SelectList(ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)), "BidItemId", "BidItemId"); ModelState.AddModelError("", BusinessConstants.ValidateEntries); return(View("billing/aiabilling", modelBilling)); } } else { ViewBag.UOMTypes = new SelectList(Atlas.DataAccess.Entity.Common.getUnitofMeasure(), "UnitOfMeasure", "UomDescription"); //ar BidItems = ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)).Select(i=>i.BidItemId); ViewBag.BidItems = new SelectList(ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)), "BidItemId", "BidItemId"); ModelState.AddModelError("", "Project cannot be saved! Please try again"); return(View("billing/aiabilling", modelBilling)); } } else { ViewBag.UOMTypes = new SelectList(Atlas.DataAccess.Entity.Common.getUnitofMeasure(), "UnitOfMeasure", "UomDescription"); //ar BidItems = ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)).Select(i=>i.BidItemId); ViewBag.BidItems = new SelectList(ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)), "BidItemId", "BidItemId"); ModelState.AddModelError("", BusinessConstants.ValidateEntries); return(View("billing/aiabilling", modelBilling)); } } catch (Exception e) { ViewBag.UOMTypes = new SelectList(Atlas.DataAccess.Entity.Common.getUnitofMeasure(), "UnitOfMeasure", "UomDescription"); //ar BidItems = ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)).Select(i=>i.BidItemId); ViewBag.BidItems = new SelectList(ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)), "BidItemId", "BidItemId"); Logger.SaveErr(e); ModelState.AddModelError("", BusinessConstants.contactAdmin); return(View("billing/aiabilling", modelBilling)); } }
internal static AIABilling getAIABilling(string PRJID, object BIDID) { AIABilling modelBilling = null; try { var data = SqlHelper.ExecuteDataset(_myConnection, CommandType.StoredProcedure, "spATL_ADM_JobBillDtMain_AIA_Get_Dtls", new SqlParameter("@PRJID", PRJID), new SqlParameter("@BIDID", BIDID)); if (data.Tables[0].Rows.Count == 1) { var result = data.Tables[0]; modelBilling = new AIABilling { CommissionExpires = Convert.ToDateTime(result.Rows[0]["CommissionExpires"]).Date, ApplicationNum = Convert.ToInt32(result.Rows[0]["ApplicationNum"]), BillingDate = Convert.ToDateTime(result.Rows[0]["BillingDate"]), EntryDate = Convert.ToDateTime(result.Rows[0]["EntryDate"]), NotaryDate = Convert.ToDateTime(result.Rows[0]["NotaryDate"]), OriginalContractSum = Convert.ToInt32(result.Rows[0]["OriginalContractSum"]), NetChangeByCO = Convert.ToInt32(result.Rows[0]["NetChangeByCO"]), ItemNo = Convert.ToString(result.Rows[0]["ItemNo"]), QtyOfBI = Convert.ToInt32(result.Rows[0]["QtyOfBI"]), UnitOfMeasure = Convert.ToString(result.Rows[0]["UnitOfMeasure"]), UnitPrice = Convert.ToString(result.Rows[0]["UnitPrice"]), BilledQty = Convert.ToInt32(result.Rows[0]["BilledQty"]), Accept = Convert.ToBoolean(result.Rows[0]["Accept"]), }; } } catch (Exception ex) { Logger.SaveErr(ex); } return(modelBilling); }