// /PurchaseRequests/Change [POST]
public ActionResult Change([FromBody] PurchaseRequests purchaseRequest)
{
PurchaseRequests purchaseRequests2 = db.PurchaseRequests.Find(purchaseRequest.Id);
if (purchaseRequests2 == null)
{
return(Json(new JsonMessage("Failure", "Record that needs to be changed has been deleted"), JsonRequestBehavior.AllowGet));
}
purchaseRequests2.Id = purchaseRequest.Id;
purchaseRequests2.UserId = purchaseRequest.UserId;
purchaseRequests2.Description = purchaseRequest.Description;
purchaseRequests2.Justification = purchaseRequest.Justification;
purchaseRequests2.DeliveryMode = purchaseRequest.DeliveryMode;
purchaseRequests2.Status = purchaseRequest.Status;
purchaseRequests2.Total = purchaseRequest.Total;
purchaseRequests2.Active = purchaseRequest.Active;
purchaseRequests2.ReasonForRejection = purchaseRequest.ReasonForRejection;
purchaseRequests2.DateCreated = purchaseRequest.DateCreated;
purchaseRequests2.DateUpdated = purchaseRequest.DateUpdated;
purchaseRequests2.UpdatedByUser = purchaseRequest.UpdatedByUser;
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return(Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet));
}
return(Json(new JsonMessage("Success", "Purchase Request was updated")));
}
public UCPQ(PurchaseRequests pr)
{
InitializeComponent();
ILoad <PriceQuotations> load = new LoadAddEditPQ(this, pr);
load.Init();
}
public UCPO(PurchaseRequests purchaseRequests)
{
InitializeComponent();
LoadAddEditPO loadAddEditPO = new LoadAddEditPO(this, purchaseRequests);
((ILoad <PurchaseOrders>)loadAddEditPO).Init();
// This line of code is generated by Data Source Configuration Wizard
}
public frmAddEditAllotmentLetter(PurchaseRequests purchaseRequests, AllotmentLetter allotmentLetter, MethodType methodType)
{
InitializeComponent();
this.purchaseRequests = purchaseRequests;
this.methodType = methodType;
this.allotmentLetter = allotmentLetter;
Init();
}
public UCAOQ(PurchaseRequests purchaseRequests)
{
InitializeComponent();
this.purchaseRequests = purchaseRequests;
Init();
btnDeletePQRepo.ButtonClick += BtnDeletePQRepo_ButtonClick;
btnEditPQRepo.ButtonClick += BtnEditPQRepo_ButtonClick;
}
public LoadAddEditPO(UCPO uCPO, PurchaseRequests purchaseRequests)
{
this.uCPO = uCPO;
this.purchaseRequests = purchaseRequests;
uCPO.btnNew.Click += BtnNew_Click;
uCPO.btnDeletePQRepo.ButtonClick += BtnDeletePQRepo_ButtonClick;
uCPO.btnEditPORepo.ButtonClick += BtnEditPORepo_ButtonClick;
uCPO.btnPreview.Click += BtnPreview_Click;
}
public LoadAddEditItems(frmItems frmItems, PurchaseRequests purchaseRequests, frmAddEditPurchaseRequest frmAddEditPurchaseRequest)
{
this.frmAddEditPurchaseRequest = frmAddEditPurchaseRequest;
this.frmItems = frmItems;
this.purchaseRequests = purchaseRequests;
frmItems.btnNew.Click += BtnNew_Click;
frmItems.btnDeleteItemRepo.ButtonClick += BtnDeleteItemRepo_Click;
frmItems.btnSelectItemRepo.ButtonClick += BtnSelectItemRepo_ButtonClick;
}
public LoadAddEditPQ(UCPQ uCPQ, PurchaseRequests purchaseRequests)
{
this.uCPQ = uCPQ;
this.pr = purchaseRequests;
uCPQ.btnDeletePQRepo.ButtonClick += BtnDeletePQRepo_ButtonClick;
uCPQ.btnEditPQRepo.ButtonClick += BtnEditPQRepo_ButtonClick;
uCPQ.btnNew.Click += BtnNew_Click;
uCPQ.btnPreview.Click += BtnPreview_Click;
}
public frmSelectedItem(PurchaseRequests pr, PurchaseOrders po, frmAddEditPO frm)
{
InitializeComponent();
this.frm = frm;
this.pr = pr;
this.po = po;
this.btnSelectItemRepo.ButtonClick += BtnSelectItemRepo_ButtonClick;
Init();
}
public frmAddEditPurchaseRequest(MethodType methodType, PurchaseRequests item)
{
InitializeComponent();
var tran = new LoadAddEditPurchaseRequest(this, item)
{
methodType = methodType
};
transaction = ((ITransactions <PurchaseRequests>)tran);
transaction.Init();
this.Item = tran.item;
}
// /PurchaseRequest/Remove [POST]
public ActionResult Remove([FromBody] PurchaseRequests purchaseRequest)
{
PurchaseRequests purchaseRequests2 = db.PurchaseRequests.Find(purchaseRequest.Id);
db.PurchaseRequests.Remove(purchaseRequests2);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return(Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet));
}
return(Json(new JsonMessage("Success", "Purchase Request was removed")));
}
public IHttpActionResult Post(string itemName)
{
// In case we need the request API key, we get it this way:
// string apiKey = RequestContext.Principal.Identity.Name;
var item = new PurchaseRequests(dataStore).PostHandler(itemName);
if (item == null)
{
return(BadRequest("Invalid item name"));
}
else
{
return(CreatedAtRoute("GetItemByName", new { itemName = item.Name }, item));
}
}
// /PurchaseRequests/Get/5
public ActionResult Get(int?id)
{
if (id == null)
{
return(Json(new Utility.JsonMessage("Failure", "Id is null"), JsonRequestBehavior.AllowGet));
}
PurchaseRequests purchaseRequests = db.PurchaseRequests.Find(id);
if (purchaseRequests == null)
{
return(Json(new JsonMessage("Failure", "Id is not found"), JsonRequestBehavior.AllowGet));
}
//return Json(purchaseRequest, JsonRequestBehavior.AllowGet);
return(new JsonNetResult {
Data = purchaseRequests
});
}
// /PurchaseRequests/Create [POST]
public ActionResult Create([FromBody] PurchaseRequests purchaseRequest)
{
if (!ModelState.IsValid)
{
return(Json(new JsonMessage("Failure", "ModelState is not valid"), JsonRequestBehavior.AllowGet));
}
db.PurchaseRequests.Add(purchaseRequest);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return(Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet));
}
return(Json(new JsonMessage("Success", "Purchase Request was created")));
}
public UCAIReports(PurchaseRequests purchaseRequests)
{
InitializeComponent();
this.purchaseRequests = purchaseRequests;
Init();
}
public UCAPRs(PurchaseRequests pr)
{
InitializeComponent();
this.pr = pr;
Init();
}
public frmItems(PurchaseRequests item, frmAddEditPurchaseRequest frmAddEditPurchaseRequest)
{
InitializeComponent();
this.loadAddEditItems = new LoadAddEditItems(this, item, frmAddEditPurchaseRequest);
((ILoad <Items>)loadAddEditItems).Init();
}
private void btnDuplicate_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (this.PRGrid.GetFocusedRow() is PurchaseRequests item)
{
try
{
if (MessageBox.Show("Do you want to submit this?", "Submit", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
UnitOfWork unitOfWork = new UnitOfWork();
var pr = unitOfWork.PurchaseRequestsRepo.Fetch().OrderByDescending(x => x.Id).FirstOrDefault();
StaticSettings staticSettings = new StaticSettings();
var res = new PurchaseRequests()
{
ControlNo = IdHelper.OfficeControlNo(pr.ControlNo, staticSettings.OfficeId, "PR",
"PurchaseRequests"),
AppropriationId = item.AppropriationId,
CreatedBy = User.UserId,
Date = DateTime.Now,
OfficeId = item.OfficeId,
DeptHead = item.DeptHead,
Description = item.Description,
Year = item.Year,
TotalAmount = item.TotalAmount,
TableName = item.TableName,
Purpose = item.Purpose,
DeptHeadPos = item.DeptHeadPos,
PAPos = item.PAPos,
PA = item.PA,
DivisionHead = item.DivisionHead,
DivisionHeadPos = item.DivisionHeadPos,
IsEarmark = item.IsEarmark,
};
var pRDetails = new List <PRDetails>();
foreach (var i in item.PRDetails)
{
pRDetails.Add(new PRDetails()
{
Category = i.Category,
Cost = i.Cost,
Item = i.Item,
ItemNo = i.ItemNo,
ItemId = i.ItemId,
Quantity = i.Quantity,
TableName = i.TableName,
TotalAmount = i.TotalAmount,
UOM = i.UOM,
});
}
res.PRDetails = pRDetails;
unitOfWork.PurchaseRequestsRepo.Insert(res);
unitOfWork.Save();
((ILoad <PurchaseRequests>) this.loadAddEditPurchaseRequest).Init();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public UCPIS(PurchaseRequests purchaseRequests)
{
InitializeComponent();
this.purchaseRequests = purchaseRequests;
Init();
}
public UCAllotmentLetter(PurchaseRequests purchaseRequests)
{
InitializeComponent();
this.purchaseRequests = purchaseRequests;
Detail(purchaseRequests?.AllotmentLetter.FirstOrDefault());
}
