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