public ActionResult Create(int StockId)
{
Stock = new clsT_Stock().GetStockDetailByStockId(StockId);
Bids = new BidsM { StockId = Stock.StockId, ItemId = Stock.ItemId, ItemCode = Stock.ItemCode, ItemName = Stock.ItemName, LocationId = Stock.LocationId, GradeId = Stock.GradeId, UOMId = Stock.UOMId, Quantity = Stock.Quantity, UnitPrice = Stock.UnitPrice };
ViewBag.Location = getLocation();
ViewBag.Grade = GetItemGrade(Stock.ItemId);
ViewBag.UOM = getUOM();
return View(Bids);
}
public ActionResult SaveRequest()
{
BidsM Bids = new BidsM();
Bids.RequestedBy = commonFunctions.GetTransactionEmployeeCode();
TryUpdateModel(Bids);
if (ModelState.IsValid)
{
ErrorMsg = clsT_Bids.SaveRequest(Bids, out RequestNo);
if (!string.IsNullOrEmpty(ErrorMsg))
{
TempData["Message"] = new MessageBox {
CssClassName = ".alert-danger", Title = "Error!", Message = "Transaction was rollback.Try again."
};
ViewBag.Location = getLocation();
ViewBag.Grade = GetItemGrade(Bids.ItemId);
ViewBag.UOM = getUOM();
return(RedirectToAction("Create", Bids.StockId));
}
else
{
ViewBag.Location = getLocation();
ViewBag.Grade = GetItemGrade(Bids.StockId);
ViewBag.UOM = getUOM();
TempData["Message"] = new MessageBox {
CssClassName = ".alert-success", Title = "Success!", Message = "Your Request No: " + RequestNo
};
return(RedirectToAction("ViewStock", "Stock"));
}
}
return(View());
}
public string SaveRequest(BidsM Bid, out string RequestNo)
{
p = new SqlParameter[10];
try
{
p[0] = new SqlParameter("@StockId", SqlDbType.Int);
p[0].Value = Bid.StockId;
p[1] = new SqlParameter("@ItemId", SqlDbType.Int);
p[1].Value = Bid.ItemId;
p[2] = new SqlParameter("@GradeId", SqlDbType.Int);
p[2].Value = Bid.GradeId;
p[3] = new SqlParameter("@RequiredDate", SqlDbType.Date);
p[3].Value = Bid.RequiredDate;
p[4] = new SqlParameter("@RequiredQty", SqlDbType.Decimal);
p[4].Value = Bid.RequestedQty;
p[5] = new SqlParameter("@RequiredPrice", SqlDbType.Decimal);
p[5].Value = Bid.RequestedPrice;
p[6] = new SqlParameter("@LocationId", SqlDbType.Int);
p[6].Value = Bid.LocationId;
p[7] = new SqlParameter("@CreatedBy", SqlDbType.Int);
p[7].Value = Bid.RequestedBy;
p[8] = new SqlParameter("@Result", SqlDbType.VarChar, 400);
p[8].Direction = ParameterDirection.Output;
p[9] = new SqlParameter("@ERRMSG", SqlDbType.VarChar, 400);
p[9].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(clsConnectionString.getConnectionString(), CommandType.StoredProcedure, "spInsertRequirmentD", p);
RequestNo = p[8].Value.ToString();
return(p[9].Value.ToString());
}
catch (Exception ex)
{
throw ex;
}
}
