public ActionResult QuotationForm(int formNo)
{
ViewBag.formCount = Request.Form["formNo"];
//Common Method to be called for Purchase Quotation Form
SubmitPurchaseQuotationViewModel pqvm = PurchaseQuotationCommon();
return(PartialView(pqvm));
}
public ViewResult AddPurchaseQuotation()
{
ViewBag.Title = Constant.ADD_PURCHASE_QUOTATION;
//Common Method to be called for Purchase Quotation Form
SubmitPurchaseQuotationViewModel pqvm = PurchaseQuotationCommon();
return(View(pqvm));
}
public PartialViewResult EditQuotation(int id)
{
//Common Method to be called for Purchase Quotation Form
SubmitPurchaseQuotationViewModel spqvm = PurchaseQuotationCommon();
spqvm.quotationDetails = _repPurchaseQuotation.GetQuotationDetails(id);
return(PartialView(spqvm));
}
public ActionResult NewField(string field)
{
ViewBag.formCount = Request.Form["formNo"];
var counter = Request.Form["counter"];
//Common Method to be called for Purchase Quotation Form
SubmitPurchaseQuotationViewModel pqvm = PurchaseQuotationCommon();
if (field.Equals("existing"))
{
return(PartialView("ExistingField", pqvm));
}
else
{
return(PartialView(pqvm));
}
}
public ActionResult EditQuotation(int id, FormCollection fc)
{
var updateStatus = 0;
//Common Method to be called for Purchase Quotation Form
SubmitPurchaseQuotationViewModel spqvm = PurchaseQuotationCommon();
try
{
spqvm.AssetListId = fc["formValue[AssetList]"];
spqvm.Price = fc["formValue[Price]"];
spqvm.VAT = fc["formValue[VAT]"];
spqvm.Quantity = fc["formValue[Quantity]"];
spqvm.PurchaseType = fc["formValue[PurchaseType]"];
spqvm.QuotedDate = fc["formValue[QuotedDate]"];
var Username = SessionHelper.Username;
var CreatedDate = DateTime.Now;
var UserId = SessionHelper.UserId;
var currentAnnualBudgetId = new BaseController(_repAnnualBudget).budgetList;
if (ModelState.IsValid)
{
_repPurchaseQuotation.UpdateQuotationDetails(spqvm, id);
_repPurchaseQuotation.UpdateQuotationEntryLog(spqvm, id, UserId, Username, CreatedDate, currentAnnualBudgetId);
updateStatus = 1;
return(Content(updateStatus.ToString()));
}
}
catch (IOException e)
{
if (e.Source != null)
{
Console.WriteLine("IOException source: {0}", e.Source);
throw;
}
}
spqvm.quotationDetails = _repPurchaseQuotation.GetQuotationDetails(id);
return(View(spqvm));
}
private SubmitPurchaseQuotationViewModel PurchaseQuotationCommon()
{
var pqvm = new SubmitPurchaseQuotationViewModel();
//List Item for Purchase Type
List <SelectListItem> objPurchaseType = new List <SelectListItem>();
objPurchaseType.Add(new SelectListItem {
Text = "--Select Purchase Type--"
});
objPurchaseType.Add(new SelectListItem {
Text = "Brand New", Value = "Brand New"
});
objPurchaseType.Add(new SelectListItem {
Text = "Second Hand", Value = "Second Hand"
});
pqvm.compPurchaseType = objPurchaseType;
pqvm.assetLst = _repAsset.GetAssetInfo().ToList();
//List Item for Asset List
List <SelectListItem> objAssetList = new List <SelectListItem>();
bool assetTypeSelected = false;
objAssetList.Add(new SelectListItem {
Text = "-- Select Asset--"
});
foreach (var item in pqvm.assetLst)
{
objAssetList.Add(new SelectListItem
{
Text = String.Concat(item.AssetName, " (", item.AssetCategoryName, ")"),
Value = item.Id.ToString(),
Selected = assetTypeSelected
});
}
pqvm.AssetList = objAssetList;
return(pqvm);
}
/// <summary>
/// Updates Purchase Quotation Entry Log
/// </summary>
/// <param name="lstPurchaseQuotation">SubmitPurchaseQuotationViewModel object</param>
/// <param name="id">Purchase Quotation Entry Log ID</param>
/// <param name="userid">User ID</param>
/// <param name="username">Username</param>
/// <param name="createddate">Created Date</param>
/// <param name="budgetId">Budget ID</param>
public void UpdateQuotationEntryLog(SubmitPurchaseQuotationViewModel purchaseQuotation, int id, long userId, string username, DateTime createddate, long budgetId)
{
var date = DateTime.ParseExact(purchaseQuotation.QuotedDate.ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd");
var QueryString = String.Format(
@" INSERT INTO {0} (AssetId, AnnualBudgetId, UserId, AssetPrice, VAT, Quantity, QuotedDate, IsApproved, PurchaseType, ActionType, Username, CreatedDate)
VALUES ({1}, {2}, {3}, {4}, {5}, {6}, '{7}', {8}, '{9}', '{10}', '{11}', '{12}')",
TableConstant.TBL_PURCHASE_QUOTATION_ENTRY_LOG,
purchaseQuotation.AssetListId,
budgetId,
userId,
purchaseQuotation.Price,
purchaseQuotation.VAT,
purchaseQuotation.Quantity,
date,
1,
purchaseQuotation.PurchaseType,
"Update",
username,
createddate);
ado.ExecNonQuery(QueryString);
}
/// <summary>
/// Updates Purchase Quotation Details
/// </summary>
/// <param name="lstPurchaseQuotation">SubmitPurchaseQuotationViewModel object</param>
/// <param name="id">Purchase Quotation ID</param>
public void UpdateQuotationDetails(SubmitPurchaseQuotationViewModel purchaseQuotation, int id)
{
var date = DateTime.ParseExact(purchaseQuotation.QuotedDate.ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd");
ado.ExecNonQuery(
String.Format(
@" UPDATE {0}
SET AssetId = {1},
AssetPrice = {2},
VAT = {3},
Quantity = {4},
QuotedDate = '{5}',
PurchaseType = '{6}'
WHERE Id = {7}",
TableConstant.TBL_PURCHASE_QUOTATION,
purchaseQuotation.AssetListId,
purchaseQuotation.Price,
purchaseQuotation.VAT,
purchaseQuotation.Quantity,
date,
purchaseQuotation.PurchaseType,
id)
);
}
public ActionResult AddPurchaseQuotation(FormCollection fc)
{
var currentAnnualBudgetId = new BaseController(_repAnnualBudget).budgetList;
ViewBag.Title = Constant.ADD_PURCHASE_QUOTATION;
//Common Method to be called for Purchase Quotation Form
SubmitPurchaseQuotationViewModel pqvm = PurchaseQuotationCommon();
try
{
pqvm.AssetListId = fc["AssetList"];
pqvm.Price = fc["Price"];
pqvm.VAT = fc["VAT"];
pqvm.Quantity = fc["Quantity"];
pqvm.PurchaseType = fc["PurchaseType"];
pqvm.QuotedDate = fc["QuotedDate"];
var lstAssetListId = pqvm.AssetListId.Split(',').ToList();
var lstPrice = pqvm.Price.Split(',').ToList();
var lstVAT = pqvm.VAT.Split(',').ToList();
var lstQuantity = pqvm.Quantity.Split(',').ToList();
var lstPurchaseType = pqvm.PurchaseType.Split(',').ToList();
var lstQuotedDate = pqvm.QuotedDate.Split(',').ToList();
var lstPurchaseQuotation = new List <PurchaseQuotation>();
for (int i = 0; i < lstAssetListId.Count; i++)
{
var pq = new PurchaseQuotation();
pq.AssetId = long.Parse(lstAssetListId[i]);
pq.AnnualBudgetId = currentAnnualBudgetId;
pq.UserId = SessionHelper.UserId;
pq.AssetPrice = decimal.Parse(lstPrice[i]);
pq.VAT = decimal.Parse(lstVAT[i]);
pq.Quantity = int.Parse(lstQuantity[i]);
pq.PurchaseType = lstPurchaseType[i];
pq.QuotedDate = DateTime.Parse(lstQuotedDate[i]);
lstPurchaseQuotation.Add(pq);
}
var lstPqEnryLog = new List <PurchaseQuotationEntryLog>();
for (int i = 0; i < lstAssetListId.Count; i++)
{
var pqel = new PurchaseQuotationEntryLog();
pqel.AssetId = long.Parse(lstAssetListId[i]);
pqel.AnnualBudgetId = currentAnnualBudgetId;
pqel.UserId = SessionHelper.UserId;
pqel.AssetPrice = decimal.Parse(lstPrice[i]);
pqel.VAT = decimal.Parse(lstVAT[i]);
pqel.Quantity = int.Parse(lstQuantity[i]);
pqel.PurchaseType = lstPurchaseType[i];
pqel.QuotedDate = DateTime.Parse(lstQuotedDate[i]);
pqel.IsApproved = 1;
pqel.ActionType = "Create";
pqel.Username = SessionHelper.Username;
pqel.CreatedDate = DateTime.Now;
lstPqEnryLog.Add(pqel);
}
if (ModelState.IsValid)
{
_repPurchaseQuotation.AddPurchaseQuotationInfo(lstPurchaseQuotation, lstPqEnryLog);
FlashMessage.Confirmation("Purchase quotation has been added successfully.");
return(RedirectToAction("QuotationDetails"));
}
}
catch (IOException e)
{
// Extract some information from this exception, and then
// throw it to the parent method.
if (e.Source != null)
{
Console.WriteLine("IOException source: {0}", e.Source);
throw;
}
}
return(View(pqvm));
}
