//----------------------------------------------------------------END--------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------------------------------------------------------------
//-------------------------------------------------------------------EDIT-----------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------------------------
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProceedRealizationMas procRelMas = db.ProceedRealizationMas.Find(id);
if (procRelMas == null)
{
return(HttpNotFound());
}
var paymentType = new SelectList(new List <SelectListItem> {
new SelectListItem {
Text = "LC", Value = "0"
}, new SelectListItem {
Text = "TT", Value = "1"
},
}, "Value", "Text", procRelMas.PaymentTypeId);
ViewBag.PaymentTypeId = paymentType;
ViewBag.BuyerInfoId = new SelectList(db.BuyerInfo.Where(x => x.PaymentTypeId == procRelMas.PaymentTypeId), "Id", "Name", procRelMas.BuyerInfoId);
ViewBag.DocSubmissionMasId = new SelectList(db.DocSubmissionMas.Where(x => x.BuyerInfoId == procRelMas.BuyerInfoId), "Id", "FDBCNo", procRelMas.DocSubmissionMasId);
ViewBag.ProceedDate = NullHelpers.DateToString(db.ProceedRealizationMas.SingleOrDefault(x => x.Id == id).ProceedDate);
var lcNo = (from docMas in db.DocSubmissionMas
join proceedRelMas in db.ProceedRealizationMas on docMas.Id equals proceedRelMas.DocSubmissionMasId
where proceedRelMas.Id == id
select docMas.MasterLCInfoMas.LCNo).Distinct();
ViewBag.MasterLCNo = lcNo.SingleOrDefault();
return(View(procRelMas));
}
public JsonResult UpdateData(IEnumerable <ProceedRealizationDet> InvoiceDetails, ProceedRealizationMas InvoiceMas)
{
var result = new
{
flag = false,
message = "Error occured. !"
};
try
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var relMas = db.ProceedRealizationMas.Find(InvoiceMas.Id);
if (relMas == null)
{
result = new
{
flag = false,
message = "Invoice not found, Saving Failed !!"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
relMas.ProceedDate = InvoiceMas.ProceedDate;
db.Entry(relMas).State = EntityState.Modified;
db.SaveChanges();
foreach (var item in InvoiceDetails)
{
if (item.Id == 0) //insert
{
item.ProceedRealizationMasId = relMas.Id;
//item.ExFactoryShipDetId = item.ExFactoryShipDetId;
db.ProceedRealizationDet.Add(item);
}
else //update
{
var oItem = db.ProceedRealizationDet.Find(item.Id);
oItem.ProceedQty = item.ProceedQty;
db.Entry(oItem).State = EntityState.Modified;
}
db.SaveChanges();
}
dbContextTransaction.Commit();
result = new
{
flag = true,
message = "Updating successful !!"
};
//Success("Updated successfully.", true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
result = new
{
flag = false,
message = ex.Message
};
}
}
}
catch (Exception ex)
{
result = new
{
flag = false,
message = ex.Message
};
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveData(IEnumerable <ProceedRealizationDet> InvoiceDetails, ProceedRealizationMas InvoiceMas)
{
var result = new
{
flag = false,
message = "Error occured. !",
Id = 0
};
try
{
var OpDate = DateTime.Now;
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
db.ProceedRealizationMas.Add(InvoiceMas);
db.SaveChanges();
foreach (var item in InvoiceDetails)
{
item.ProceedRealizationMasId = InvoiceMas.Id;
item.ProceedQty = item.ProceedQty;
item.DocSubmissionDetId = item.DocSubmissionDetId;
db.ProceedRealizationDet.Add(item);
db.SaveChanges();
}
dbContextTransaction.Commit();
result = new
{
flag = true,
message = "Saving successful!",
Id = InvoiceMas.Id
};
//Success("Record saved successfully.", true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
result = new
{
flag = false,
message = ex.Message,
Id = 0
};
}
}
}
catch (Exception ex)
{
result = new
{
flag = false,
message = ex.Message,
Id = 0
};
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
