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 EditStock(string stockId)
{
StockM stock = new StockM();
if (stockId != string.Empty)
{
stock = clsT_Stock.GetStockDetailByStockId(int.Parse(stockId));
}
ViewBag.Location = getLocation();
ViewBag.Grade = GetItemGrade(stock.ItemId);
ViewBag.UOM = getUOM();
return(View(stock));
}
public ActionResult CreateStock(int ID)
{
StockM stock = new StockM();
ItemM ItemM = clsM_Item.GetItemByItemId(ID);
ViewBag.Location = getLocation();
ViewBag.Grade = GetItemGrade(ID);
ViewBag.UOM = getUOM();
stock.ItemId = ItemM.ItemId;
stock.ItemCode = ItemM.ItemCode;
stock.ItemName = ItemM.ItemName;
return(View(stock));
}
public ActionResult UpdateStock_POST()
{
StockM stock = new StockM();
TryUpdateModel(stock);
if (ModelState.IsValid)
{
stock.EmployeeCode = commonFunctions.GetTransactionEmployeeCode();
ErrorMsg = clsT_Stock.UpdateStock(stock, out StockNo);
if (!string.IsNullOrEmpty(ErrorMsg))
{
TempData["Message"] = new MessageBox {
CssClassName = ".alert-danger", Title = "Error!", Message = "Your Stock No: " + StockNo + "-" + ErrorMsg
};
ViewBag.Location = getLocation();
ViewBag.Grade = GetItemGrade(stock.ItemId);
ViewBag.UOM = getUOM();
return(View("EditStock"));
}
else
{
ViewBag.Location = getLocation();
ViewBag.Grade = GetItemGrade(stock.ItemId);
ViewBag.UOM = getUOM();
TempData["Message"] = new MessageBox {
CssClassName = ".alert-success", Title = "Success!", Message = "Your Stock No: " + StockNo + "- Successfully Updated"
};
return(View("EditStock"));
//return RedirectToAction("UpdateStock", stock.ItemId);
}
}
return(View());
}
public ActionResult CreateStock_POST()
{
StockM stock = new StockM();
TryUpdateModel(stock);
if (ModelState.IsValid)
{
stock.EmployeeCode = commonFunctions.GetTransactionEmployeeCode();
ErrorMsg = clsT_Stock.SaveStock(stock, out StockNo);
if (!string.IsNullOrEmpty(ErrorMsg))
{
TempData["Message"] = new MessageBox {
CssClassName = ".alert-danger", Title = "Error!", Message = "Transaction was rollback.Try again.<br>"
};
ViewBag.Location = getLocation();
ViewBag.Grade = GetItemGrade(stock.ItemId);
ViewBag.UOM = getUOM();
return(View(stock));
}
else
{
ViewBag.Location = getLocation();
ViewBag.Grade = GetItemGrade(stock.ItemId);
ViewBag.UOM = getUOM();
TempData["Message"] = new MessageBox {
CssClassName = ".alert-success", Title = "Success!", Message = "Your Last Stock Nos: " + StockNo
};
return(RedirectToAction("CreateStock", stock.ItemId));
}
}
return(View());
}
public string SaveStock(StockM StockM, out string StockNo)
{
p = new SqlParameter[11];
try
{
p[0] = new SqlParameter("@ItemId", SqlDbType.Int);
p[0].Value = StockM.ItemId;
p[1] = new SqlParameter("@EmployeeCode", SqlDbType.VarChar, 50);
p[1].Value = StockM.EmployeeCode;
p[2] = new SqlParameter("@LocationId", SqlDbType.Int);
p[2].Value = StockM.LocationId;
p[3] = new SqlParameter("@GradeId", SqlDbType.Int);
p[3].Value = StockM.GradeId;
p[4] = new SqlParameter("@Quantity", SqlDbType.Decimal);
p[4].Value = StockM.Quantity;
p[5] = new SqlParameter("@UOMId", SqlDbType.Int);
p[5].Value = StockM.UOMId;
p[6] = new SqlParameter("@UnitPrice", SqlDbType.Decimal);
p[6].Value = StockM.UnitPrice;
p[7] = new SqlParameter("@Result", SqlDbType.VarChar, 400);
p[7].Direction = ParameterDirection.Output;
p[8] = new SqlParameter("@ERRMSG", SqlDbType.VarChar, 400);
p[8].Direction = ParameterDirection.Output;
p[9] = new SqlParameter("@Description", SqlDbType.VarChar);
p[9].Value = StockM.Description;
p[10] = new SqlParameter("@AddStockUntill", SqlDbType.Date);
p[10].Value = StockM.CreateUntill;
SqlHelper.ExecuteNonQuery(clsConnectionString.getConnectionString(), CommandType.StoredProcedure, "spInsertStockD", p);
StockNo = p[7].Value.ToString();
return(p[8].Value.ToString());
}
catch (Exception ex)
{
throw ex;
}
}
public StockM GetStockDetailByStockId(int StockId)
{
StockM Stock = new StockM();
p = new SqlParameter[1];
p[0] = new SqlParameter("@StockId", SqlDbType.Int)
{
Value = StockId
};
using (reader = SqlHelper.ExecuteReader(clsConnectionString.getConnectionString(), CommandType.StoredProcedure, "spSelectStockByStockId", p))
{
while (reader.Read())
{
Stock = new StockM
{
StockId = int.Parse(reader["StockId"].ToString()),
ItemId = int.Parse(reader["ItemId"].ToString()),
ItemName = reader["ItemName"].ToString(),
EmployeeCode = reader["EmployeeCode"].ToString(),
LocationId = int.Parse(reader["LocationId"].ToString()),
GradeId = int.Parse(reader["GradeId"].ToString()),
Grade = reader["Grade"].ToString(),
Quantity = decimal.Parse(reader["Quantity"].ToString()),
UOMId = int.Parse(reader["UOMId"].ToString()),
UOMName = reader["UOMName"].ToString(),
UnitPrice = decimal.Parse(reader["UnitPrice"].ToString()),
CreatedDate = DateTime.Parse(reader["CreatedDate"].ToString()),
Location = reader["LocationName"].ToString(),
Description = reader["Description"].ToString(),
StockOwner = reader["NickName"].ToString()
};
}
return(Stock);
}
}
