public ActionResult ModifyPO(string id)
{
clsPOSetup posetup = new clsPOSetup();
List <dropdown> cust = new List <dropdown>();
TCCGDataContext dbcontext = new TCCGDataContext();
var q_po_profile = from aa in dbcontext.TCCG_PO_MSTRs
where aa.PO_NUM == id
select aa;
posetup.ponum = id;
posetup.podate = DateTime.Parse(q_po_profile.First().PO_DATE.ToString()).ToShortDateString();
var q_tccg_customer = from aa in dbcontext.TCCG_CUSTOMERs
where aa.cust_status == "SID005"
select new { aa.CUSTOMER_CODE, aa.CUSTOMER_NAME };
cust.Add(new dropdown {
displayvalue = "=Select=", valuemember = "=Select="
});
foreach (var row in q_tccg_customer)
{
cust.Add(new dropdown {
displayvalue = row.CUSTOMER_NAME, valuemember = row.CUSTOMER_CODE
});
}
posetup.customer = cust;
ViewBag.cusid = q_po_profile.First().PO_CUSTOMER;
return(View(posetup));
}
public ActionResult CreatePO()
{
clsPOSetup posetup = new clsPOSetup();
List <dropdown> cust = new List <dropdown>();
TCCGDataContext dbcontext = new TCCGDataContext();
//posetup.ponum = clsfunc.CodeGenerator(procedure.constring(), "po_num", "tbl_100_PO", "PO-" + DateTime.Now.ToString("MMddyy"), 10, 3);
posetup.ponum = "[SYSTEM GENERATED]";
posetup.podate = DateTime.Now.Date.ToShortDateString();
var q_tccg_customer = from aa in dbcontext.TCCG_CUSTOMERs
where aa.cust_status == "SID005"
select new { aa.CUSTOMER_CODE, aa.CUSTOMER_NAME };
cust.Add(new dropdown {
displayvalue = "=Select=", valuemember = "=Select="
});
foreach (var row in q_tccg_customer)
{
cust.Add(new dropdown {
displayvalue = row.CUSTOMER_NAME, valuemember = row.CUSTOMER_CODE
});
}
posetup.customer = cust;
return(View(posetup));
}
public JsonResult SavePO(clsPOSetup posetup)
{
try
{
string ponum = string.Empty;
if (posetup.ponum == "[SYSTEM GENERATED]")
{
ponum = "PO" + DateTime.Now.ToString("yyMMddfff");
}
else
{
ponum = posetup.ponum;
}
dbcontext.SPROC_TCCG_PO_MSTR(ponum,
DateTime.Parse(posetup.podate),
posetup.customercode,
posetup.baseprice,
posetup.convertedamt,
"SID012");
var q_dtl_del = from aa in dbcontext.TCCG_PO_DTLs
where aa.PO_NUM == ponum
select aa;
if (q_dtl_del.Any())
{
foreach (var row in q_dtl_del)
{
dbcontext.TCCG_PO_DTLs.DeleteOnSubmit(row);
}
}
foreach (var row in posetup.podetail)
{
string itm_cde = "ITM" + DateTime.Now.ToString("yyMMddfff");
dbcontext.SPROC_TCCG_PO_DTL(ponum,
itm_cde,
row.qty,
row.make,
row.model,
row.vin_engine,
row.baseprice,
row.sellingprice,
row.actulalamt,
row.convertedamt,
true);
}
dbcontext.SubmitChanges();
return(Json(new { result = true, err = string.Empty }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { result = false, err = ex.Message }));
}
}
