public IHttpActionResult DeleteAssetQuotationById(int id)
{
AssetQuotation objassetQuotation = db.AssetQuotations.Find(id);
if (objassetQuotation == null)
{
return(NotFound());
}
objassetQuotation.IsActive = false;
objassetQuotation.LastModifiedOn = System.DateTime.Now;
objassetQuotation.LastModifiedBy = objassetQuotation.LastModifiedBy;
db.Entry(objassetQuotation).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AssetQuotationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok("Updated"));
}
public IHttpActionResult PostAssetQuotation()
{
long assetRequestId, vendorId, quantity = 0;
decimal price, cgst, sgst;
string comments = string.Empty;
string status = string.Empty;
string createdBy = string.Empty;
try
{
HttpResponseMessage response = new HttpResponseMessage();
var httpRequest = HttpContext.Current.Request;
assetRequestId = Convert.ToInt64(httpRequest.Form["EntityTypeId"]);
vendorId = Convert.ToInt64(httpRequest.Form["VendorId"]);
quantity = Convert.ToInt64(httpRequest.Form["Quantity"]);
price = Convert.ToDecimal(httpRequest.Form["Price"]);
comments = httpRequest.Form["Comments"];
cgst = Convert.ToDecimal(httpRequest.Form["CGST"]);
sgst = Convert.ToDecimal(httpRequest.Form["SGST"]);
createdBy = httpRequest.Form["CreatedBy"];
var assetVendor = db.AssetQuotations.Where(x => x.AssetVendorId == vendorId && x.AssetRequestId == assetRequestId && x.IsActive == true).Select(x => x.Id).FirstOrDefault();
if (assetVendor == 0)
{
if (httpRequest.Form.Keys.Count > 0)
{
AssetQuotation assetQuotation = new AssetQuotation();
assetQuotation.AssetRequestId = assetRequestId;
assetQuotation.AssetVendorId = vendorId;
assetQuotation.Price = price;
assetQuotation.Quantity = quantity;
assetQuotation.Comments = (comments == "undefined") ? string.Empty : comments;
assetQuotation.Documents = "";
assetQuotation.CGST = cgst;
assetQuotation.SGST = sgst;
assetQuotation.IsActive = true;
assetQuotation.CreatedOn = System.DateTime.Now;
assetQuotation.CreatedBy = (createdBy == "undefined") ? 0 : Convert.ToInt16(createdBy);
db.AssetQuotations.Add(assetQuotation);
db.SaveChanges();
var fileUpload = new AssetDocumentsController();
var result = fileUpload.FileUpload(assetQuotation.Id, Convert.ToInt16(createdBy));
status = "success";
}
}
else
{
status = "exist";
}
}
catch (Exception)
{
throw;
}
return(Ok(status));
}
public IHttpActionResult InsertAssetQuotation(AssetQuotationModel assetQuotationModel)
{
string retMsg = string.Empty;
string AssetStatus = "Awaiting Quotation Approval";
long RaiseRequestId = assetQuotationModel.AssetRequestId;
try
{
if (assetQuotationModel.SpecificationArray.Count() > 0)
{
var dbAssetStatusId = db.AssetStatus.Where(c => c.Name.ToUpper() == AssetStatus.ToUpper()).Select(x => x.Id).FirstOrDefault();
foreach (var itms in assetQuotationModel.SpecificationArray)
{
var dbVendorId = db.AssetVendors.Where(x => x.Name == itms.Name).Select(c => c.Id).FirstOrDefault();
AssetQuotation assetQuotation = new AssetQuotation();
assetQuotation.AssetRequestId = assetQuotationModel.AssetRequestId;
assetQuotation.AssetVendorId = dbVendorId;
assetQuotation.Price = itms.Price;
assetQuotation.Quantity = itms.Quantity;
assetQuotation.Comments = itms.Comments;
assetQuotation.Documents = itms.Documents;
assetQuotation.CGST = itms.CGST;
assetQuotation.SGST = itms.SGST;
assetQuotation.IsActive = true;
assetQuotation.CreatedOn = System.DateTime.Now;
assetQuotation.CreatedBy = assetQuotation.CreatedBy;
db.AssetQuotations.Add(assetQuotation);
db.SaveChanges();
}
var assetRequest = db.AssetRequests.SingleOrDefault(x => x.Id == RaiseRequestId);
if (assetRequest != null)
{
assetRequest.AssetStatusId = dbAssetStatusId;
assetRequest.LastModifiedOn = System.DateTime.Now;
db.SaveChanges();
}
retMsg = "Updated";
}
}
catch (Exception)
{
throw;
}
return(Ok(retMsg));
}
