//----------------------------------------------------------------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 ActionResult Edit(int id)
{
ViewBag.ExMasId = id;
//var selectedRdlPrev = (from buyerDiscountMas in db.DiscountAdjustmentBuyerMas
// join buyerDiscountPrev in db.DiscountAdjustmentBuyerPrev on buyerDiscountMas.Id equals buyerDiscountPrev.DiscountAdjustmentBuyerMasId
// join buyOrderMas in db.BuyerOrderMas on buyerDiscountPrev.BuyerOrderMasId equals buyOrderMas.Id
// where buyerDiscountMas.Id == id
// select buyOrderMas).SingleOrDefault();
//var selectedRdlAdj = (from buyerDiscountMas in db.DiscountAdjustmentBuyerMas
// join buyerDiscountAdj in db.DiscountAdjustmentBuyerAdj on buyerDiscountMas.Id equals buyerDiscountAdj.DiscountAdjustmentBuyerMasId
// join buyOrderMas in db.BuyerOrderMas on buyerDiscountAdj.BuyerOrderMasId equals buyOrderMas.Id
// where buyerDiscountMas.Id == id
// select buyOrderMas).SingleOrDefault();
var selectedBuyerSupplier = (from adjustBuyerMas in db.DiscountAdjustmentBuyerMas
// join buyInfo in db.BuyerInfo on adjustBuyerMas.BuyerInfoId equals buyInfo.Id
where adjustBuyerMas.Id == id
select adjustBuyerMas).SingleOrDefault();
ViewBag.BuyerInfoId = new SelectList(db.BuyerInfo.OrderBy(x => x.Name), "Id", "Name", selectedBuyerSupplier.BuyerInfoId);
ViewBag.SupplierId = new SelectList(db.Supplier.OrderBy(x => x.Name), "Id", "Name", selectedBuyerSupplier.SupplierId);
//ViewBag.RdlRefNoPrev = new SelectList(db.BuyerOrderMas.OrderBy(x => x.OrderRefNo), "Id", "Name", selectedRdlPrev.OrderRefNo);
//ViewBag.RdlRefNoAdj = new SelectList(db.BuyerOrderMas.OrderBy(x => x.OrderRefNo), "Id", "Name", selectedRdlAdj.OrderRefNo);
ViewBag.DateAdj = NullHelpers.DateToString(db.DiscountAdjustmentBuyerMas.SingleOrDefault(x => x.Id == id).DateAdj);
return(View());
}
public JsonResult GetSavedData(int Id)
{
var data = (from activityMas in db.ActionActivityMas
join activityDet in db.ActionActivityDet on activityMas.Id equals activityDet.ActionActivityMasId
where activityMas.Id == Id
select new
{
ActionActivityDetId = activityDet.Id,
timeActionDetId = activityDet.TimeActionDetId,
ActivityName = activityDet.TimeActionDet.ActivityName,
ActivityDays = activityDet.TimeActionDet.ActivityDays,
PlanDate = activityDet.PlanDate,
RevisedDate = activityDet.RevisedDate,
ActualDate = activityDet.ActualDate,
Remarks = activityDet.Remarks,
Source = activityDet.TimeActionDet.Source
}).ToList();
var refinedata = data.AsEnumerable().Select(x => new
{
ActionActivityDetId = x.ActionActivityDetId,
timeActionDetId = x.timeActionDetId,
ActivityName = x.ActivityName,
ActivityDays = x.ActivityDays,
PlanDate = NullHelpers.DateToString(x.PlanDate),
RevisedDate = x.RevisedDate == null ? "" : NullHelpers.DateToString(x.RevisedDate),
ActualDate = x.ActualDate == null ? "" : NullHelpers.DateToString(x.ActualDate),
Remarks = x.Remarks == null ? "" : x.Remarks,
Source = x.Source
}).Distinct();
return(Json(refinedata, JsonRequestBehavior.AllowGet));
}
//[HttpPost]
//[ValidateAntiForgeryToken]
//public ActionResult Create([Bind(Include = "Id,FactoryOrderDelivDetId,TimeActionMasId,PlanFlag,RevisedFlag")] ActionActivityMas actionActivityMas)
//{
// if (ModelState.IsValid)
// {
// db.ActionActivityMas.Add(actionActivityMas);
// db.SaveChanges();
// return RedirectToAction("Index");
// }
// ViewBag.FactoryOrderDelivDetId = new SelectList(db.FactoryOrderDelivDet, "Id", "Id", actionActivityMas.FactoryOrderDelivDetId);
// ViewBag.TimeActionMasId = new SelectList(db.TimeActionMas, "Id", "TemplateName", actionActivityMas.TimeActionMasId);
// return View(actionActivityMas);
//}
// GET: ActionActivity/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ActionActivityMas actionActivityMas = db.ActionActivityMas.Find(id);
if (actionActivityMas == null)
{
return(HttpNotFound());
}
var factoryDet = db.FactoryOrderDet.SingleOrDefault(x => x.Id == actionActivityMas.FactoryOrderDelivDet.FactoryOrderDetId);
ViewBag.RDLRefNo = factoryDet.BuyerOrderDet.BuyerOrderMas.OrderRefNo;
ViewBag.OrderDate = NullHelpers.DateToString(factoryDet.BuyerOrderDet.BuyerOrderMas.OrderDate);
ViewBag.Style = factoryDet.BuyerOrderDet.StyleNo;
ViewBag.OrderQty = factoryDet.BuyerOrderDet.Quantity;
ViewBag.TimeActionMasId = new SelectList(db.TimeActionMas.Where(x => x.BuyerInfoId == factoryDet.BuyerOrderDet.BuyerOrderMas.BuyerInfoId), "Id", "TemplateName", actionActivityMas.TimeActionMasId);
//ViewBag.ShipmentSummDetId = new SelectList(db.ShipmentSummDet.Where(x => x.BuyerOrderDetId == factoryDet.BuyerOrderDetId), "Id", "BuyerSlNo");
ViewBag.ShipmentSummDetId = new SelectList(db.ShipmentSummDet.Where(x => x.BuyerOrderDetId == factoryDet.BuyerOrderDetId), "Id", "DelivSlno", actionActivityMas.FactoryOrderDelivDet.ShipmentSummDetId);
//ViewBag.FactoryOrderDelivDetId = new SelectList(db.FactoryOrderDelivDet, "Id", "Id", actionActivityMas.FactoryOrderDelivDetId);
//ViewBag.TimeActionMasId = new SelectList(db.TimeActionMas, "Id", "TemplateName", actionActivityMas.TimeActionMasId);
return(View(actionActivityMas));
}
// GET: ActionActivity/Create
public ActionResult Create(int factoryOrderDetId)
{
var factoryDet = db.FactoryOrderDet.SingleOrDefault(x => x.Id == factoryOrderDetId);
ViewBag.BuyerMasId = factoryDet.BuyerOrderDet.BuyerOrderMasId;
ViewBag.RDLRefNo = factoryDet.BuyerOrderDet.BuyerOrderMas.OrderRefNo;
ViewBag.OrderDate = NullHelpers.DateToString(factoryDet.BuyerOrderDet.BuyerOrderMas.OrderDate);
ViewBag.Style = factoryDet.BuyerOrderDet.StyleNo;
ViewBag.OrderQty = factoryDet.BuyerOrderDet.Quantity;
ViewBag.TimeActionMasId = new SelectList(db.TimeActionMas.Where(x => x.BuyerInfoId == factoryDet.BuyerOrderDet.BuyerOrderMas.BuyerInfoId), "Id", "TemplateName");
//ViewBag.ShipmentSummDetId = new SelectList(db.ShipmentSummDet.Where(x=>x.BuyerOrderDetId == factoryDet.BuyerOrderDetId), "Id", "BuyerSlNo");
ViewBag.ShipmentSummDetId = new SelectList(db.ShipmentSummDet.Where(x => x.BuyerOrderDetId == factoryDet.BuyerOrderDetId), "Id", "DelivSlno");
return(View());
}
public JsonResult GetTimeActionList(int Id, int BuyerMasId)
{
List <VMActionActivityList> list = new List <VMActionActivityList>();
var data = (from timeActionDet in db.TimeActionDet
where timeActionDet.TimeActionMasId == Id
select new
{
timeActionDetId = timeActionDet.Id,
ActivityName = timeActionDet.ActivityName,
ActivityDays = timeActionDet.ActivityDays,
Source = timeActionDet.Source
}).ToList();
foreach (var item in data)
{
VMActionActivityList vm = new VMActionActivityList();
vm.timeActionDetId = item.timeActionDetId;
vm.ActivityName = item.ActivityName;
vm.ActivityDays = item.ActivityDays;
if (item.Source == 1)
{
vm.PlanDate = NullHelpers.DateToString(db.BuyerOrderMas.SingleOrDefault(x => x.Id == BuyerMasId).OrderDate);
vm.Source = "Order Confirmation Date";
}
else if (item.Source == 2)
{
//Exfactory maybe will come from FactoryOrderDelivDet
//vm.PlanDate = NullHelpers.DateToString(db.ExFactoryDet.FirstOrDefault(x=>x.BuyerOrderMasId == BuyerMasId).ExFactoryMas.ExFactoryDate);
vm.PlanDate = NullHelpers.DateToString(db.ExFactoryDet.FirstOrDefault(x => x.BuyerOrderMasId == BuyerMasId).ExFactoryMas.ExFactoryDate);
vm.Source = "Exfactory Date";
}
else
{
vm.PlanDate = "";
vm.Source = "";
}
list.Add(vm);
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
