public ActionResult GenerateAMCQuotation(AMCQuotationPartialModel model)
{
if (model.CommissioningId != 0)
{
bool isExists = _dbRepositoryAMCQ.GetEntities().Any(m => m.CommissioningId == model.CommissioningId &&
m.ActualAmount == model.QuotationAmount &&
m.GSTPercentage == model.GSTPercentage);
if (isExists)
{
return(Json(new { id = String.Empty, error = "Quotation with same amount & GST percentage already exists." }, JsonRequestBehavior.AllowGet));
}
tblCommissioning commissioningObj = _dbRepository.SelectById(model.CommissioningId);
tblPreCommissioningDetail preCommissioningDetail = _dbRepositoryPreCD.GetEntities()
.Where(m => m.PCDetailId == commissioningObj.PreCommissioningDetailId)
.Include(m => m.tblPreCommissioning).FirstOrDefault();
tblAMCQuotation quotatationObj = new tblAMCQuotation();
quotatationObj.CommissioningId = commissioningObj.CommissioningId;
quotatationObj.MachineModelId = commissioningObj.MachineModelId.Value;
quotatationObj.MachineTypeId = commissioningObj.MachineTypeId.Value;
quotatationObj.MachineSerialNo = commissioningObj.MachineSerialNo;
quotatationObj.CustomerId = preCommissioningDetail.tblPreCommissioning.CustomerId;
quotatationObj.QuotationDate = DateTime.Now.Date;
quotatationObj.ActualAmount = model.QuotationAmount;
quotatationObj.GSTPercentage = model.GSTPercentage;
quotatationObj.GSTAmount = model.GSTAmount;
quotatationObj.CGSTPercentage = model.GSTPercentage / 2;
quotatationObj.CGSTAmount = model.GSTAmount / 2;
quotatationObj.TotalAmount = model.TotalAmount;
quotatationObj.TotalAmountInWords = CurrencyHelper.changeCurrencyToWords(model.TotalAmount);
quotatationObj.IsConvertedIntoAMC = false;
quotatationObj.CreatedBy = SessionHelper.UserId;
quotatationObj.CreatedDate = DateTime.Now.Date;
string result = _dbRepositoryAMCQ.Insert(quotatationObj);
if (string.IsNullOrEmpty(result))
{
return(Json(new { id = quotatationObj.Id.ToString(), error = String.Empty }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { id = String.Empty, error = "Something Went Wrong." }, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveModelData(tblAMCQuotation model)
{
if (!ModelState.IsValid)
{
ViewBag.CustomerList = SelectionList.CustomerList().Select(m => new { m.CustomerId, m.CustomerName });
ViewBag.MachineTypeList = SelectionList.MachineTypeList().Select(m => new { m.MachineTypeId, m.MachineTypeName });
ViewBag.MachineModelList = SelectionList.MachineModelsList().Select(m => new { m.MachineModelId, m.MachineName });
return(View("Create", model));
}
string message = string.Empty;
try
{
model.CGSTPercentage = model.GSTPercentage / 2;
model.CGSTAmount = model.GSTAmount / 2;
model.TotalAmountInWords = CurrencyHelper.changeCurrencyToWords(model.TotalAmount);
if (model.Id > 0)
{
model.ModifiedBy = SessionHelper.UserId;
model.ModifiedDate = DateTime.Now;
message = _dbRepository.Update(model);
}
else
{
model.CreatedBy = SessionHelper.UserId;
model.CreatedDate = DateTime.Now;
message = _dbRepository.Insert(model);
}
}
catch (Exception ex)
{
message = CommonHelper.GetErrorMessage(ex);
}
return(RedirectToAction("Index"));
}
public string GenerateAMC(AMCPartialModel model)
{
if (model.AMCQuotationId != 0)
{
tblAMCQuotation quotation = _dbRepository.SelectById(model.AMCQuotationId);
if (quotation != null)
{
tblAMC amcObj = new tblAMC();
amcObj.AMCQuotationId = quotation.Id;
amcObj.CustomerId = quotation.CustomerId;
amcObj.MachineModelId = quotation.MachineModelId;
amcObj.MachineTypeId = quotation.MachineTypeId;
amcObj.MachineSerialNo = quotation.MachineSerialNo;
amcObj.AMCQuotationNo = quotation.AMCQuotationNo;
amcObj.ActualAmount = quotation.ActualAmount;
amcObj.GSTPercentage = quotation.GSTPercentage;
amcObj.GSTAmount = quotation.GSTAmount;
amcObj.TotalAmount = quotation.TotalAmount;
amcObj.Remarks = model.Remarks;
amcObj.AMCStartDate = DateTime.Now.Date;
amcObj.AMCEndDate = DateTime.Now.Date.AddYears(1);
amcObj.IsAMCExpired = false;
amcObj.CreatedBy = SessionHelper.UserId;
amcObj.CreatedDate = DateTime.Now.Date;
string result = _dbRepositoryAMC.Insert(amcObj);
if (string.IsNullOrEmpty(result))
{
quotation.IsApproved = true;
//quotation.IsConvertedIntoAMC = true;
_dbRepository.Update(quotation);
List <tblAMCQuotation> quotationList = new List <tblAMCQuotation>();
if (quotation.CommissioningId != 0)
{
quotationList = _dbRepository.GetEntities().Where(m => m.CommissioningId == quotation.CommissioningId).ToList();
foreach (tblAMCQuotation obj in quotationList)
{
obj.IsConvertedIntoAMC = true;
_dbRepository.Update(obj);
}
}
else
{
quotationList = _dbRepository.GetEntities().Where(m => m.CustomerId == quotation.CustomerId && m.MachineTypeId == quotation.MachineTypeId &&
m.MachineModelId == quotation.MachineModelId &&
m.MachineSerialNo == quotation.MachineSerialNo).ToList();
foreach (tblAMCQuotation obj in quotationList)
{
obj.IsConvertedIntoAMC = true;
_dbRepository.Update(obj);
}
}
if (quotation.CommissioningId != null && quotation.CommissioningId != 0)
{
tblCommissioning commsioningObj = _dbRepositoryCommissioning.SelectById(quotation.CommissioningId);
commsioningObj.IsConvertedToAMC = true;
_dbRepositoryCommissioning.Update(commsioningObj);
}
tblAMCServices amcServie1 = new tblAMCServices();
amcServie1.AMCId = amcObj.AMCId;
amcServie1.ServiceDate = DateTime.Now.Date.AddMonths(3);
amcServie1.IsServiceDone = false;
amcServie1.CreatedBy = SessionHelper.UserId;
amcServie1.CreatedDate = DateTime.Now.Date;
_dbRepositoryAMCService.Insert(amcServie1);
tblAMCServices amcServie2 = new tblAMCServices();
amcServie2.AMCId = amcObj.AMCId;
amcServie2.ServiceDate = DateTime.Now.Date.AddMonths(6);
amcServie2.IsServiceDone = false;
amcServie2.CreatedBy = SessionHelper.UserId;
amcServie2.CreatedDate = DateTime.Now.Date;
_dbRepositoryAMCService.Insert(amcServie2);
tblAMCServices amcServie3 = new tblAMCServices();
amcServie3.AMCId = amcObj.AMCId;
amcServie3.ServiceDate = DateTime.Now.Date.AddMonths(9);
amcServie3.IsServiceDone = false;
amcServie3.CreatedBy = SessionHelper.UserId;
amcServie3.CreatedDate = DateTime.Now.Date;
_dbRepositoryAMCService.Insert(amcServie3);
tblAMCServices amcServie4 = new tblAMCServices();
amcServie4.AMCId = amcObj.AMCId;
amcServie4.ServiceDate = DateTime.Now.Date.AddDays(1);
amcServie4.IsServiceDone = false;
amcServie4.CreatedBy = SessionHelper.UserId;
amcServie4.CreatedDate = DateTime.Now.Date;
_dbRepositoryAMCService.Insert(amcServie4);
return(amcObj.AMCId.ToString());
}
}
}
return(String.Empty);
}
public ActionResult KendoDestroy([DataSourceRequest] DataSourceRequest request, tblAMCQuotation model)
{
string deleteMessage = _dbRepository.Delete(model.Id);
ModelState.Clear();
if (!string.IsNullOrEmpty(deleteMessage))
{
ModelState.AddModelError(deleteMessage, deleteMessage);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
