public bool CreateRequisition(Requisition modelReq)
{
bool isSuccessful = false;
LogicUniStoreModel dbContext;
try
{
dbContext = new LogicUniStoreModel();
dbContext.Database.Connection.Open();
using (var txn = dbContext.Database.BeginTransaction())
{
//Create Adjustment and Items
RequisitionDao dao = new RequisitionDao(dbContext);
dao.Create(modelReq);
RequisitionItemDao itemDao = new RequisitionItemDao(dbContext);
foreach (RequisitionItem item in modelReq.RequisitionItems)
{
itemDao.addRequisitionItem(item);
}
txn.Commit();
isSuccessful = true;
}
dbContext.Database.Connection.Close();
}
catch (Exception ex)
{
// throw;
}
return(isSuccessful);
}
public ProcessReqController()
{
LogicUniStoreModel db = new LogicUniStoreModel();
RequisitionDao = new RequisitionDao(db);
StockCardDao = new StockCardDao(db);
RequisitionItemDao = new RequisitionItemDao(db);
mainList = new Dictionary <Requisition, double>();
LockedItem = new Dictionary <int, int>();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
LUUser user = (LUUser)Session["User"];
if (user == null)
{
throw new InvalidOperationException("User Is not valid");
}
if (ViewState["items"] != null)
{
items = (List <CartItem>)ViewState["items"];
RequisitionItemDao dao = new RequisitionItemDao();
Requisition requisition = new Requisition();
requisition.ReqDate = System.DateTime.Now;
requisition.ReqNumber = requisitionNum; //Todo
requisition.Status = RequisitionStatus.Requested.ToString();
requisition.RequesterID = user.UserID; // Todo: need to change later once login up
requisition.DepartmentID = user.DepartmentID.Value; // Todo: same
requisition.RecieveByID = user.Department.HodID; //Todo: same
requisition.Remark = tbRemarks.Text;
dao.db.Requisitions.Add(requisition);
foreach (var cartItem in items)
{
RequisitionItem item = new RequisitionItem();
item.SupplierItemID = cartItem.SupplierItem.SupplierItemId;
item.NeededQuantity = cartItem.Quantity;
item.ReqID = requisition.ReqID;
item.IsOutstanding = false;
dao.db.RequisitionItems.Add(item);
}
dao.db.SaveChanges();
#region Send Notifications
NotificationController ctl = new NotificationController();
ctl.CreateNotification(
user.UserID, string.Format("New approval Requisition request {0}", requisition.ReqNumber), NotificationStatus.Created, Roles.HOD, user.DepartmentID.Value
);
string toEmailIds = new UserController().GetToEmailIds(Roles.HOD, user.DepartmentID.Value); //To which role the email should be sent
ctl.SendEmail("*****@*****.**", toEmailIds, "New requisition approval request", "New Requisition has been for approval : " + requisition.ReqNumber);
#endregion
reset();
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "alertRedirect('Requested Submited for Approval !!!','EmpMain.aspx')", true);
}
}
public void addRequisitionItem(RequisitionItem item)
{
RequisitionItemDao.addRequisitionItem(item);
}
public void removeRequisitionItems(int reqId)
{
RequisitionItemDao.deleteRequisitionItem(reqId);
}
public CancelUpdatePendingApprovalController()
{
RequisitionDao = new RequisitionDao();
RequisitionItemDao = new RequisitionItemDao();
ItemDao = new ItemDao();
}
public ReapplyRejectedController()
{
RequisitionDao = new RequisitionDao();
RequisitionItemDao = new RequisitionItemDao();
ItemDao = new ItemDao();
}
public CancelUpdateUnallocatedController()
{
RequisitionDao = new RequisitionDao();
riDao = new RequisitionItemDao();
iDao = new ItemDao();
}
public ClerkMainController()
{
LogicUniStoreModel db = new LogicUniStoreModel();
RequisitionItemDao = new RequisitionItemDao(db);
}
