public JsonResult Edit(QuotationMasterViewModel Quotmasterviewmodel)
{
bool status = false;
Repository.QuotationRepository quotrepo = new Repository.QuotationRepository();
quotrepo.UpdateQuotationMaster(Quotmasterviewmodel);
status = true;
return(new JsonResult {
Data = new { status = status }
});
}
public QuotationMasterViewModel AddQuotationMaster(QuotationMasterViewModel str)
{
QuotationMaster pur = new QuotationMaster();
pur.CustomerID = str.CustomerID;
pur.QuoteNumber = str.QuoteNumber;
pur.QuoteDate = str.QuoteDate;
pur.QuoteRevDate = str.QuoteRevDate;
pur.StoreID = int.Parse(System.Web.HttpContext.Current.Session["storeid"].ToString());
pur.UserID = int.Parse(System.Web.HttpContext.Current.Session["userid"].ToString());
pur.AddedUser = System.Web.HttpContext.Current.Session["username"].ToString();
cntxt.QuotationMasters.Add(pur);
cntxt.SaveChanges();
foreach (QuotationDetailsViewModel strdet in str.QuotationDetailsViewModels)
{
QuotationDetail quotationDetail = new QuotationDetail();
quotationDetail.QuotationMasterId = pur.QuotationMasterid;
quotationDetail.CategoryID = strdet.CategoryID;
quotationDetail.ItemNameID = strdet.ItemNameID;
quotationDetail.Specification = strdet.Specification;
quotationDetail.Qty = strdet.Qty;
quotationDetail.TotalPrice = strdet.TotalPrice;
quotationDetail.UnitPrice = strdet.UnitPrice ?? 00;
quotationDetail.CGSTPercent = strdet.CGSTPercent;
quotationDetail.SGSTPercent = strdet.SGSTPercent;
quotationDetail.AddedUser = System.Web.HttpContext.Current.Session["username"].ToString();
quotationDetail.AddedDate = DateTime.Now;
quotationDetail.IsDeleted = false;
cntxt.QuotationDetails.Add(quotationDetail);
}
cntxt.SaveChanges();
return(str);
}
public QuotationMasterViewModel UpdateQuotationMaster(QuotationMasterViewModel Quotmater)
{
var q = from invmstr in cntxt.QuotationMasters
where invmstr.QuotationMasterid == Quotmater.QuotationMasterid
select invmstr;
foreach (var element in q)
{
element.CustomerID = Quotmater.CustomerID;
element.QuoteNumber = Quotmater.QuoteNumber;
element.QuoteDate = Quotmater.QuoteDate;
element.QuoteRevDate = Quotmater.QuoteRevDate;
element.ModifiedUser = System.Web.HttpContext.Current.Session["username"].ToString();
element.ModifiedDate = DateTime.Now;
}
foreach (QuotationDetailsViewModel Quotdet in Quotmater.QuotationDetailsViewModels)
{
if (!cntxt.QuotationDetails.Any(f => f.QuotationDetailId == Quotdet.QuotationDetailId))
{
QuotationDetail quotationDetail = new QuotationDetail();
quotationDetail.QuotationMasterId = Quotmater.QuotationMasterid;
quotationDetail.CategoryID = Quotdet.CategoryID;
quotationDetail.ItemNameID = Quotdet.ItemNameID;
quotationDetail.Specification = Quotdet.Specification;
quotationDetail.Qty = Quotdet.Qty;
quotationDetail.TotalPrice = Quotdet.TotalPrice;
quotationDetail.UnitPrice = Quotdet.UnitPrice ?? 00;
quotationDetail.CGSTPercent = Quotdet.CGSTPercent;
quotationDetail.SGSTPercent = Quotdet.SGSTPercent;
quotationDetail.AddedUser = System.Web.HttpContext.Current.Session["username"].ToString();
quotationDetail.AddedDate = DateTime.Now;
quotationDetail.IsDeleted = false;
cntxt.QuotationDetails.Add(quotationDetail);
}
else
{
if (Quotdet.QuotationDetailId != 0)
{
var q1 = from ivoidedetail in cntxt.QuotationDetails
where ivoidedetail.QuotationDetailId == Quotdet.QuotationDetailId
select ivoidedetail;
foreach (var element in q1)
{
element.CategoryID = Quotdet.CategoryID;
element.ItemNameID = Quotdet.ItemNameID;
element.Specification = Quotdet.Specification;
element.Qty = Quotdet.Qty;
element.TotalPrice = Quotdet.TotalPrice;
element.UnitPrice = Quotdet.UnitPrice ?? 00;
element.CGSTPercent = Quotdet.CGSTPercent;
element.SGSTPercent = Quotdet.SGSTPercent;
element.ModifiedUser = System.Web.HttpContext.Current.Session["username"].ToString();
element.ModifiedDate = DateTime.Now;
}
}
else
{
QuotationDetail quotationDetail = new QuotationDetail();
quotationDetail.QuotationMasterId = Quotmater.QuotationMasterid;
quotationDetail.CategoryID = Quotdet.CategoryID;
quotationDetail.ItemNameID = Quotdet.ItemNameID;
quotationDetail.Specification = Quotdet.Specification;
quotationDetail.Qty = Quotdet.Qty;
quotationDetail.TotalPrice = Quotdet.TotalPrice;
quotationDetail.UnitPrice = Quotdet.UnitPrice ?? 00;
quotationDetail.CGSTPercent = Quotdet.CGSTPercent;
quotationDetail.SGSTPercent = Quotdet.SGSTPercent;
quotationDetail.AddedUser = System.Web.HttpContext.Current.Session["username"].ToString();
quotationDetail.AddedDate = DateTime.Now;
quotationDetail.IsDeleted = false;
cntxt.QuotationDetails.Add(quotationDetail);
}
}
}
var alreadyenteredinvoicelist = from ivoidedetail in cntxt.QuotationDetails
where ivoidedetail.QuotationMasterId == Quotmater.QuotationMasterid && ivoidedetail.QuotationDetailId != 0
select ivoidedetail;
foreach (var element in alreadyenteredinvoicelist)
{
//if (!Quotmater.InvoiceDetails.Any(f => f.InvoiceDetailID == element.InvoiceDetailID))
if (!Quotmater.QuotationDetailsViewModels.Any(f => f.QuotationDetailId == element.QuotationDetailId))
{
element.IsDeleted = true;
element.DeletedUser = System.Web.HttpContext.Current.Session["username"].ToString();
element.Deleteddate = DateTime.Now;
element.Qty = 0;
}
}
cntxt.SaveChanges();
return(Quotmater);
}
