public IActionResult DeleteByID(int ID)
{
/*Check Session */
var page = "272";
var typeofuser = "";
var PermisionAction = "";
// CheckSession
if (string.IsNullOrEmpty(HttpContext.Session.GetString("Username")))
{
Alert("กรุณา Login เข้าสู่ระบบ", NotificationType.error);
return(RedirectToAction("Login", "Accounts"));
}
else
{
typeofuser = HttpContext.Session.GetString("TypeOfUserId");
PermisionAction = HttpContext.Session.GetString("PermisionAction");
if (PermisionHelper.CheckPermision(typeofuser, PermisionAction, page) == false)
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
}
/*Check Session */
IActionResult response = Unauthorized();
//var documentBilling = new DocumentBilling();
var documentBilling = new DocumentBilling();
var documentBillings = _context.DocumentBillings.Where(a => a.ID == ID).ToList();
if (documentBillings.Count > 0)
{
_context.DocumentBillings.Remove(documentBillings[0]);
_context.SaveChanges();
response = Ok(new { data = documentBillings[0], datatype = "1" });
}
else
{
response = Ok(new { data = documentBilling, datatype = "0" });
}
return(response);
}
public IActionResult AddData(int ID, string date1, string PO, string vendor, string site, string invoice, string Delivery, string Etc)
{
/*Check Session */
var page = "270";
var typeofuser = "";
var PermisionAction = "";
// CheckSession
if (string.IsNullOrEmpty(HttpContext.Session.GetString("Username")))
{
Alert("กรุณา Login เข้าสู่ระบบ", NotificationType.error);
return(RedirectToAction("Login", "Accounts"));
}
else
{
typeofuser = HttpContext.Session.GetString("TypeOfUserId");
PermisionAction = HttpContext.Session.GetString("PermisionAction");
if (PermisionHelper.CheckPermision(typeofuser, PermisionAction, page) == false)
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
}
/*Check Session */
IActionResult response = Unauthorized();
var dStartdate = date1.Substring(6, 4) + "-" + date1.Substring(3, 2) + "-" + date1.Substring(0, 2) + " 00:00:00";
var StartDate = DateTime.Parse(dStartdate);
var documentBilling = new DocumentBilling();
if (ID == null)
{
documentBilling.PostingDate = StartDate;
documentBilling.PONo = PO;
documentBilling.Site = site;
documentBilling.VendorName = vendor;
documentBilling.DeliveryOrder = Delivery;
documentBilling.InvoiceNo = invoice;
documentBilling.Etc = Etc;
documentBilling.CreateBy = HttpContext.Session.GetString("Username");
documentBilling.CreateDate = DateTime.Now;
_context.DocumentBillings.Add(documentBilling);
_context.SaveChanges();
response = Ok(new { data = documentBilling, datatype = "บันทึก" });
}
else
{
var documentBillings = _context.DocumentBillings.Where(a => a.ID == ID).ToList();
if (documentBillings.Count == 0)
{
documentBilling.PostingDate = StartDate;
documentBilling.PONo = PO;
documentBilling.Site = site;
documentBilling.VendorName = vendor;
documentBilling.DeliveryOrder = Delivery;
documentBilling.InvoiceNo = invoice;
documentBilling.Etc = Etc;
documentBilling.CreateBy = HttpContext.Session.GetString("Username");
documentBilling.CreateDate = DateTime.Now;
_context.DocumentBillings.Add(documentBilling);
_context.SaveChanges();
response = Ok(new { data = documentBilling, datatype = "บันทึก" });
}
else
{
documentBillings[0].PostingDate = StartDate;
documentBillings[0].PONo = PO;
documentBillings[0].Site = site;
documentBillings[0].VendorName = vendor;
documentBillings[0].DeliveryOrder = Delivery;
documentBillings[0].InvoiceNo = invoice;
documentBillings[0].Etc = Etc;
documentBillings[0].UpdateBy = HttpContext.Session.GetString("Username");
documentBillings[0].UpdateDate = DateTime.Now;
_context.DocumentBillings.Update(documentBillings[0]);
_context.SaveChanges();
response = Ok(new { data = documentBillings[0], datatype = "update" });
}
}
return(response);
}
