public int AddToken(Request_Token rt)
{
string sql = " insert into Request_Token(" +
"RequestCategory, ApprovedByAdmin," +
" ApprovedByAdminDate, RequestStatus, RequestStatusDate, RequestToken, DepartmentId,LocationId," +
" EnteredBy, EnteredDate, LastUpdatedBy, LastUpdatedDate, IsDeleted, DeletedDate, DeletedBy" +
")" +
" values(" +
"@RequestCategory, @ApprovedByAdmin," +
" null, @RequestStatus, null, @RequestToken, @DepartmentId,@LocationId," +
" @EnteredBy, @EnteredDate, 0, null, @IsDeleted, null, 0" +
") SELECT CAST(SCOPE_IDENTITY() as int)";
using (var db = DbHelper.GetDBConnection())
{
int a = db.Query <int>(sql, rt).SingleOrDefault();
db.Close();
return(a);
}
}
public ActionResult Request_Asset(FormCollection frm, string[] hddrowindex)
{
int depid = Convert.ToInt32(Session["DepartmentId"]);
int uid = Convert.ToInt32(Session["UserId"]);
var cdate = DateTime.Now;
int totalcount = Convert.ToInt32(frm["hddrowindex"]);
int token = 0;
Request_Token checkToken = db.TokenCount();
if (checkToken == null)
{
token = 1;
}
else
{
token = Convert.ToInt32(checkToken.RequestToken) + 1;
}
try {
Request_Token rt = new Request_Token();
rt.DepartmentId = depid;
rt.LocationId = Convert.ToInt32(frm["LocationId-1"]);
rt.RequestToken = token;
rt.RequestCategory = "Asset";
rt.ApprovedByAdmin = "Pending";
rt.RequestStatus = "Pending";
rt.IsDeleted = false;
rt.EnteredBy = uid;
rt.EnteredDate = cdate;
int tokenid = db.AddToken(rt);
if (hddrowindex != null)
{
for (int i = 1; i <= totalcount; i++)
{
if (i == Convert.ToInt32(frm["" + i]))
{
Request requestItem = new Request();
requestItem.TokenId = tokenid;
requestItem.RequestItemId = Convert.ToInt32(frm["AssetItemId-" + i]);
requestItem.RequestQuantity = Convert.ToInt32(frm["Quantity-" + i]);
requestItem.RequestedBy = uid;
requestItem.RequestedDate = cdate;
requestItem.IsDeleted = false;
requestItem.EnteredBy = uid;
requestItem.EnteredDate = cdate;
db.AddRequestItem(requestItem);
}
}
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.CategoryList = new SelectList(ddl.getAssetCategoryList(depid), "Id", "Name");
ViewBag.CategoryId = new SelectList(ddl.getAssetCategoryList(depid), "Id", "Name");
ViewBag.AssetItemList = new SelectList(ddl.getAssetItemList(depid), "Id", "Name");
ViewBag.AssetItemId = new SelectList(ddl.getAssetItemList(depid), "Id", "Name");
ViewBag.LocationList = new SelectList(ddl.getLocationList(depid), "Id", "Name");
return(View());
}
}
