public ActionResult BorrowRequest(int p = 1, string key = "", string status = "")
{
UserAuth();
var psize = 10;
var borrow_list = AssetBorrowHistoryVM.GetBorrowList(key, status);
ViewBag.total = borrow_list.Count;
ViewBag.data = borrow_list.Skip((p - 1) * psize).Take(psize);
ViewBag.PageNo = p;
ViewBag.TotalPage = Math.Ceiling(borrow_list.Count / psize + 0.0);
ViewBag.keywords = key;
return(View());
}
public JsonResult BorrowReturn()
{
var id = Request.Form["id"];
var assetid = Request.Form["assetid"];
var comment = Request.Form["comment"];
var now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var borrow_tmp = new AssetBorrowHistoryVM();
borrow_tmp.ID = id;
borrow_tmp.AssetID = assetid;
borrow_tmp.IsReturn = BorrowStatus.Returned.ToString();
borrow_tmp.ReturnComment = comment;
borrow_tmp.ReturnAt = now;
AssetBorrowHistoryVM.UpdateBorrow(borrow_tmp);
var res = new JsonResult();
res.Data = new { success = true };
return(res);
}
public JsonResult AddBorrowRequest()
{
var borrow_user = Request.Form["borrow_user"];
var pro_no = Request.Form["pro_no"];
var islong = Request.Form["islong"];
var sdate = Request.Form["sdate"];
var edate = Request.Form["edate"];
var comment = Request.Form["comment"];
var assets = (List <string>)Newtonsoft.Json.JsonConvert.DeserializeObject(Request.Form["assets"], (new List <string>()).GetType());
var borrowlist = new List <AssetBorrowHistoryVM>();
var rid = DateTime.Now.ToString("yyyyMMddHHmmss");
var table = new List <List <string> >();
var e_tmp = new List <string>();
e_tmp.Add("RequestID");
e_tmp.Add("CN");
e_tmp.Add("English Name");
e_tmp.Add("Chinese Name");
e_tmp.Add("Model");
table.Add(e_tmp);
foreach (var item in assets)
{
var tmp = new AssetBorrowHistoryVM();
tmp.RequestID = rid;
tmp.AssetID = item;
tmp.BorrowUser = borrow_user;
tmp.ProjectNo = pro_no;
tmp.IsLong = islong;
tmp.StartDate = sdate;
tmp.EndDate = edate;
tmp.BorrowComment = comment;
borrowlist.Add(tmp);
}
AssetBorrowHistoryVM.NewBorrow(borrowlist);
//send confirm email
var asset_info = AssetVM.GetAssetList("", "", "", "('" + string.Join("','", assets) + "')");
foreach (var item in asset_info)
{
e_tmp = new List <string>();
e_tmp.Add(rid);
e_tmp.Add(item.Value.CN);
e_tmp.Add(item.Value.EnglishName);
e_tmp.Add(item.Value.ChineseName);
e_tmp.Add(item.Value.Supplier);
table.Add(e_tmp);
}
var towho = borrow_user.Split(new char[] { '@' })[0];
var greeting = "Hi, " + towho;
var description = "The following device(s) have been borrowed by you on " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var content = EmailUtility.CreateTableHtml(greeting, description, null, table);
var glbcfg = CfgUtility.GetSysConfig(this);
var towholist = new List <string>();
towholist.Add(borrow_user);
if (!string.IsNullOrEmpty(glbcfg["ASSETADMINUSER"]))
{
var user_list = glbcfg["ASSETADMINUSER"].Split(new char[] { ';', ',' }, StringSplitOptions.RemoveEmptyEntries);
towholist.AddRange(user_list);
}
EmailUtility.SendEmail(this, "Borrow Device(s) -- " + DateTime.Now.ToString("MM/dd/yyyy"), towholist, content, true);
var res = new JsonResult();
res.Data = new { success = true };
return(res);
}
