public ActionResult GetPreviousRequestByDepartment()
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
List <RequestDetail> details = RequestDao.GetLatestRequisitionByDepartment(departmentId);
List <object> previousItems = new List <object>();
if (details != null)
{
foreach (var i in details)
{
var obj = new
{
ItemId = i.Item.ItemId,
Quantity = i.Quantity,
Description = i.Item.Description,
UOM = i.Item.UnitOfMeasure
};
previousItems.Add(obj);
}
}
return(Json(previousItems, JsonRequestBehavior.AllowGet));
}
public ActionResult CheckList(int ma)
{
string name = HttpContext.User.Identity.Name;
var model = new RequestDao().load(name).Where(m => m.Id.Equals(ma)).FirstOrDefault();
return(View(model));
}
/// <summary>Muda o status de uma determinada requisição</sumary>
private int ChangeStatus(int request_id, char new_status)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
RequestDao dao = new RequestDao(connection, null);
try
{
request_id = dao.ChangeStatus(request_id, new_status);
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
}
return(request_id);
}
public void AddData(string day, int idResorce, string starthour, string finalfinish)
{
RequestDao ob = new RequestDao();
string Q = "INSERT INTO UserRegistration VALUES ('" + idResorce + "','" + 1 + "',N'" + day + "',N'" + starthour + "',N'" + finalfinish + "','" + 0 + " ') ";
ob.saveData(Q);
}
public ActionResult GetMyRequisition(int requestId)
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
int userId = Convert.ToInt32(RouteData.Values["userId"]);
int rank = Convert.ToInt32(RouteData.Values["rank"]);
string layout = "";
if (rank == (int)UserRank.Clerk)
{
layout = "_StoreLayout.cshtml";
}
else
{
layout = "_DeptLayout.cshtml";
}
User u = new User()
{
UserId = userId,
Department = new Department()
{
DepartmentId = departmentId
},
Rank = rank
};
Request r = RequestDao.GetRequestById(requestId, u);
ViewData["Request"] = r;
if (r != null)
{
ViewData["LayoutName"] = layout;
return(View("MyRequest"));
}
return(RedirectToAction("myrequisitions"));
}
public ActionResult DetailRequire(int ma)
{
RequestModel model = new RequestModel();
if (ma > 0)
{
if (new Commom().CheckPermission(ma))
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
if (!new PermissionAttribute().PermissionAuthorization("Update", "REQUEST"))
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
model = new RequestDao().detail(ma);
}
else
{
if (!new PermissionAttribute().PermissionAuthorization("Create", "REQUEST"))
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
var user = new ExportReportDao().GetLevelUser(HttpContext.User.Identity.Name);
model.FirstId = GetRequestId(user.Ma_BP);
model.LateId = model.FirstId.ToString() + "/Y4CKT-" + user.Ma_BP;
model.Ma_BP = user.Ma_BP;
}
ViewBag.Depart = new SelectList(new DepartmentDao().load(), "Ma_BP", "Ten_BP");
return(PartialView("_DetailRequire", model));
}
public ActionResult ApproveRequisition(int id, string status)
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
int userId = Convert.ToInt32(RouteData.Values["userId"]);
Department d = new Department()
{
DepartmentId = departmentId
};
User u = new User()
{
UserId = userId
};
Request request = new Request()
{
ApprovedBy = u,
RequestId = id,
Department = d
};
if (status.Equals("ACCEPT"))
{
request.Status = (int)RequestStatus.Approved;
}
else
{
request.Status = (int)RequestStatus.Rejected;
}
RequestDao.ApproveRequest(request);
return(RedirectToAction("PendingRequisitions"));
}
public ActionResult GetOutStandingRequest()
{
List <Request> requests = RequestDao.GetUnFulfilledRequests();
ViewData["Requests"] = requests;
return(View("UnFulfilledRequests"));
}
static void Main(string[] args)
{
RequestDao request = new RequestDao();
var param = "CategoryId:808&CategoryType:'SiteHome'&ItemListActionName:'PostList'&PageIndex:2&ParentCategoryId:0";
// string httpResponse = request.HttpPost("http://www.cnblogs.com", param);
string httpResponse = request.HttpGet("http://www.cnblogs.com/sitehome/p/2", "");
//Console.WriteLine(httpResult);
CatchDao catchDao = new CatchDao();
//var result=catchDao.CatchHomePage_MenuList(httpResponse);
//var result = catchDao.CatchHomePage_ConcentList(httpResponse);
//if (result != null && result.Count > 0)
//{
// var author0 = result[0];
// var secondResponse = request.HttpGet(author0.ContentLink, "");
// Console.WriteLine(secondResponse);
//}
//else
//{
// Console.WriteLine("爬取异常");
//}
//var result = catchDao.CatchHomePage_FirstMenuList(httpResponse);
var result = catchDao.CatchHomePage_SecondMenuList(httpResponse);
Console.ReadKey();
}
public void BindRequestTypes()
{
List <RequestType> types = new RequestDao().GetRequestTypes(null, null, 1, 1000);
this.RequestTypes = types;
cbRequestType.DataSource = types;
}
public ActionResult LoadRequire()
{
string name = HttpContext.User.Identity.Name;
var model = new RequestDao().load(name);
return(Json(new { data = model }, JsonRequestBehavior.AllowGet));
}
/// <summary>Atualiza uma requisição</sumary>
public ObjResult Update(int request_id, Request request)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
RequestDao dao = new RequestDao(connection, transaction);
ObjResult result = new ObjResult();
try
{
request_id = dao.Update(request_id, request);
transaction.Commit();
result.Success();
result.SetData(request_id);
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
public void BindRequestStatus()
{
List <RequestStatus> statuses = new RequestDao().GetRequestStatuses(null, null, 1, 1000);
this.Statuses = statuses;
cbStatus.DataSource = statuses;
}
public ActionResult PendingMobile()
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
List <Request> requests = RequestDao.getRequestsByDepartment(departmentId);
return(Json(requests, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Valida uma requisição quanto as ações que estão sendo feitas sobre ela
/// </summary>
/// <param name="obj">É o objeto requisição</param>
/// <param name="user_id">É o usuário que está solicitando a operação</param>
/// <param name="action">É o tipo de ação que está sendo feita pelo usuário</param>
/// <returns></returns>
public List <string> Validate(Request obj, int user_id, string action)
{
List <string> list_erros = new List <string>();
RequestDao dao = new RequestDao(conn, tran);
UserDao userDao = new UserDao(conn, tran);
Request request = new Request();
if (action == "reopen" || action == "finish")
{
if (!userDao.GetPermission(user_id, "purchase", "update"))
{
list_erros.Add("Permissão Negada.");
}
}
else
{
if (!userDao.GetPermission(user_id, "purchase", action))
{
list_erros.Add("Permissão Negada.");
}
}
if (action == "update" || action == "delete" || action == "finish" || action == "reopen")
{
if (obj.req_id == 0)
{
list_erros.Add("O objeto informado se refere a um novo registro.");
return(list_erros);
}
// Verifica se o registro existe
if (dao.GetById((int)obj.req_id).req_id == 0)
{
list_erros.Add("Registro não encontrado.");
return(list_erros);
}
request = dao.GetById(obj.req_id);
if (action != "reopen" && request.req_status != "E") // --> Em digitação
{
list_erros.Add("O Status do registro não permite alterações.");
return(list_erros);
}
if (action == "reopen" && request.req_status != "A") // --> Ativa ou finalizada
{
list_erros.Add("O Status do registro não permite estorno.");
return(list_erros);
}
if (RequestIsEmpty(request.req_id))
{
list_erros.Add("A requisição não contém itens!");
return(list_erros);
}
}
return(list_erros);
}
public JsonResult RequisitionById(int id)
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
List <RequestDetail> requestDetails = RequestDao.getRequestDetailsByRequestId(id, departmentId);
return(Json(requestDetails, JsonRequestBehavior.AllowGet));
}
public ActionResult GetHistoricalRequisitions()
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
List <Request> history = RequestDao.getHistoricalRequestsByDepartment(departmentId);
ViewData["History"] = history;
return(View("RequisitionHistory"));
}
public ActionResult PendingRequisitions()
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
List <Request> requests = RequestDao.getRequestsByDepartment(departmentId);
ViewData["Requests"] = requests;
return(View("PendingRequisitions"));
}
public List <Request> LoadRequests(FormData form)
{
int? customerId = form.CustomerId;
int? requestType = form.RequestTypeId;
int? statusId = form.StatusId;
List <Request> requests = new RequestDao().GetRequests(null, customerId, statusId, 1, 100);
form.Requests = requests;
return(requests);
}
/// <summary>Exclui uma determinada requisição</sumary>
public ObjResult Delete(int request_id)
{
connection = db.GetCon();
connection.Open();
ObjResult result = new ObjResult();
List <RequestItem> items = new List <RequestItem>();
List <Message> messages = new List <Message>();
// Excluir a requisição
NpgsqlTransaction transaction = connection.BeginTransaction();
RequestDao dao = new RequestDao(connection, transaction);
RequestItemDao itemDao = new RequestItemDao(connection, transaction);
MessageDao messageDao = new MessageDao(connection, transaction);
try
{
// Verifica se a requisição possui itens
items = itemDao.GetItemsByRequest(request_id);
if (items.Count > 0)
{
// Exclui todos os itens que pertencem à requisição
foreach (RequestItem item in items)
{
itemDao.Delete(item.itm_id);
}
}
// Verifica se a requisição possui mensagens
messages = messageDao.GetMessagesBySourceKey(request_id);
if (messages.Count > 0)
{
// Exclui todas as mensagens associadas à requisição
foreach (Message msg in messages)
{
messageDao.Delete(msg.msg_id);
}
}
request_id = dao.Delete(request_id);
result.SetData(request_id);
result.Success();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
}
return(result);
}
public ActionResult DeleteRequire(int ma)
{
if (new Commom().CheckPermission(ma))
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
if (!new PermissionAttribute().PermissionAuthorization("Delete", "REQUEST"))
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
bool status = new RequestDao().Delete(ma);
return(Json(new { status = status }, JsonRequestBehavior.AllowGet));
}
private static void GenerateData()
{
for (int i = 0; i < 1000; i++)
{
Request request = new Request()
{
CustomerId = 1, Modified = DateTime.Now, Created = DateTime.Now, CreatedBy = 1, Order = i, Priority = "High", RequestDetails = " Details " + i, ModifiedBy = 3, RequestTypeId = 1, StatusId = 1
};
new RequestDao().SaveRequest(request);
}
List <Request> requests = new RequestDao().GetRequests(null, null, null, 1, 1000);
Console.WriteLine("Number of requests:" + (requests != null ? requests.Count : 0));
Console.ReadLine();
}
public List <string> Validate(RequestItem obj, int user_id, string action)
{
Request request = new Request();
RequestDao requestDao = new RequestDao(conn, tran);
RequestItemDao requestItemDao = new RequestItemDao(conn, tran);
UserDao userDao = new UserDao(conn, tran);
List <string> list_erros = new List <string>();
// Verificar permissão do usuário para realizar a operação
if (!userDao.GetPermission(user_id, "purchase", action))
{
list_erros.Add("Permissão Negada.");
return(list_erros);
}
// Verificar se a ação for criar, atualizar ou deletar, buscar a requisição referente ao item
if (action == "create" || action == "update" || action == "delete")
{
request = requestDao.GetById(obj.itm_request_id);
if (request.req_status != "E")
{
list_erros.Add("Não é possível efetuar a ação, pois o status da requisição não permite.");
}
}
// Verificar se a atualização ou exclusão é possível para o item
if (action == "update" || action == "delete")
{
// É um novo registro
if (obj.itm_id == 0)
{
list_erros.Add("O objeto informado se refere a um novo registro.");
return(list_erros);
}
// Não foi encontrado o registro
if (requestItemDao.GetById((int)obj.itm_id).itm_id == 0)
{
list_erros.Add("Registro não encontrado.");
return(list_erros);
}
}
return(list_erros);
}
public ActionResult GetDataByDepartment()
{
Dictionary <string, List <RequestDetail> > detailDict = RequestDao.GetRequestDetailsByAllDepartments();
List <object> data = new List <object>();
foreach (KeyValuePair <string, List <RequestDetail> > kV in detailDict)
{
var count = kV.Value.Sum(rd => rd.Quantity);
var obj = new
{
Department = kV.Key,
Amount = count
};
data.Add(obj);
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult CancelMyRequisitions(int requestId)
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
int userId = Convert.ToInt32(RouteData.Values["userId"]);
User u = new User()
{
UserId = userId,
Department = new Department()
{
DepartmentId = departmentId
}
};
RequestDao.CancelRequestById(requestId, u);
return(RedirectToAction("MyRequisitions"));
}
public ActionResult ReceiveItemsByDepartment(List <DisbursementDetail> details, int id)
{
Dictionary <int, DisbursementDetail> dDict = DisbursementDao.GetDisbursementDetailDictByDisbursementId(id);
//generate adjustment if items are missing
List <AdjustmentDetail> adjustmentDetails = new List <AdjustmentDetail>();
foreach (var d in details)
{
DisbursementDetail disDetail = dDict[d.DisbursementDetailId];
if (disDetail.Quantity != d.Quantity && d.Quantity < disDetail.Quantity)
{
AdjustmentDetail adDetail = new AdjustmentDetail()
{
Item = new Item()
{
ItemId = d.Item.ItemId
},
Count = disDetail.Quantity - d.Quantity
};
adjustmentDetails.Add(adDetail);
}
}
if (adjustmentDetails.Count > 0)
{
int userId = Convert.ToInt32(RouteData.Values["userId"]);
User u = new User()
{
UserId = userId
};
Adjustment ad = AdjustmentDao.InsertAdjustment(adjustmentDetails, u);
AdjustmentDao.CalculateAdjustmentCost(ad);
}
Disbursement dis = DisbursementDao.DeliverDisbursement(id, details);
//need to update the request such as status, delivered Qty
RequestDao.UpdateRequestById(dis.Request.RequestId);
return(RedirectToAction("Deliveries"));
}
public ActionResult Index(List <Item> items)
{
if (items != null)
{
foreach (var v in items)
{
if (v.ItemId == 0 || v.Quantity < 1)
{
return(new HttpStatusCodeResult(400));
}
}
try
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
int userId = Convert.ToInt32(RouteData.Values["userId"]);
Department d = new Department()
{
DepartmentId = Convert.ToInt32(departmentId)
};
User u = new User()
{
UserId = userId,
Department = d
};
RequestDao.InsertRequest(items, u);
Task.Run(() => EmailUtility.SendEmailForApproval(departmentId));
return(new HttpStatusCodeResult(200));
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
return(new HttpStatusCodeResult(400));
}
}
else
{
return(new HttpStatusCodeResult(400));
}
}
public ActionResult MyRequisitions()
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
int userId = Convert.ToInt32(RouteData.Values["userId"]);
User u = new User()
{
UserId = userId,
Department = new Department()
{
DepartmentId = departmentId
}
};
List <Request> requests = RequestDao.GetMyRequests(u);
ViewData["Requests"] = requests;
return(View());
}
public ActionResult ForwardEmail(UpdateFile form)
{
bool status = new RequestDao().User_Edit(form.Id, form.name);
if (!status)
{
return(Json(status, JsonRequestBehavior.AllowGet));
}
string template = System.IO.File.ReadAllText(HttpContext.Server.MapPath("~/Files/Templates/Approval.html"));
var tbl = new Commom().respone(form.Id);
tbl.Date_Autho = DateTime.Now.ToString("dd/MM/yyyy");
tbl.FullName = new UserDao().load().Where(m => m.UserName.Equals(HttpContext.User.Identity.Name.ToString())).FirstOrDefault().FullName;
tbl.Url = Request.Url.GetLeftPart(UriPartial.Authority) + "/Approvals/Detail?ma=" + tbl.Id;
tbl.UrlFile = Request.Url.GetLeftPart(UriPartial.Authority) + "/Files/" + form.Id + ".pdf";
string body = Engine.Razor.RunCompile(template, "checkkey", null, tbl);
status = new Commom().SendEmail(form.email, "Mail Thông Báo Kiểm Tra - " + tbl.Hang_Muc, body);
return(Json(new { status = status }, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveRequire(RequestModel data)
{
if (ModelState.IsValid)
{
data.User_Nhap = HttpContext.User.Identity.Name;
bool status;
if (data.Id > 0)
{
status = new RequestDao().Update(data);
return(Json(new { status = status }, JsonRequestBehavior.AllowGet));
}
else
{
status = new RequestDao().Save(data);
return(Json(new { status = status }, JsonRequestBehavior.AllowGet));
}
}
ViewBag.Depart = new SelectList(new DepartmentDao().load(), "Ma_BP", "Ten_BP");
return(PartialView("_DetailRequire", data));
}
