public int AddPOItem(POItemList user)
{
int id = 0;
PetaPoco.Database db = null;
var dbConn = DataContext.Database.Connection;
try
{
dbConn.Open();
db = new PetaPoco.Database(dbConn);
db.EnableAutoSelect = false;
id = db.ExecuteScalar <int>("declare @@ret INT; exec @@ret = usp_AddPOItem " + " @POId,@PROId,@PIDescription,@PIQuantity,@PIUnitPrice; select @@ret;",
new
{
@POId = user.POId,
@PROId = user.PROId,
@PIDescription = user.PIDescription,
@PIQuantity = user.PIQuantity,
@PIUnitPrice = user.PIUnitPrice
});
}
catch (Exception ex)
{
}
finally
{
if (dbConn != null)
{
dbConn.Close();
}
}
return(id);
}
public POItemList GetPOItem(int?PIID)
{
PetaPoco.Database db = null;
var dbConn = DataContext.Database.Connection;
POItemList user = new POItemList();
try
{
using (DataContext)
{
dbConn.Open();
db = new PetaPoco.Database(dbConn);
db.EnableAutoSelect = false;
user = db.Query <POItemList>("exec usp_GetPOItem " + "@PIID",
new { PIID = PIID }).FirstOrDefault();
dbConn.Close();
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (dbConn != null)
{
dbConn.Close();
}
}
return(user);
}
public JsonResult GetGRMItemsDetails(int?PIId)
{
PDService service = new PDService();
POItemList user = new POItemList();
user = service.GetPOItem(PIId);
return(Json(new { up = user.PIUnitPrice, des = user.PIDescription, qty = user.PIQuantity }, JsonRequestBehavior.AllowGet));
}
public int UpdatePOItem(POItemList user)
{
int id = 0;
try
{
id = _repository.UpdatePOItem(user);
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public ActionResult AddProduct(int?PIId)
{
PDService service = new PDService();
POItemList Product = new POItemList();
if (PIId != null)
{
Product = service.GetPOItem(PIId);
}
ViewBag.MainAssests = new SelectList(AllMainAssests(), "Value", "Text");
ViewBag.SubAssests = new SelectList(GetSubCatogoryForMC(Product.MCId), "Value", "Text");
ViewBag.ProductName = new SelectList(GetProductForSC(Product.SCId), "Value", "Text");
return(PartialView("_AddProduct", Product));
}
public POItemList GetPOItem(int?PIId)
{
POItemList user = new POItemList();
try
{
user = _repository.GetPOItem(PIId);
}
catch (Exception ex)
{
throw;
}
return(user);
}
//public ActionResult ProductGrid(int? POId)
//{
// try
// {
// PDService service = new PDService();
// PO user = new PO();
// user.POIList = service.GetPOItemList(POId);
// return PartialView("_ProductsGrid", user.POIList);
// }
// catch (Exception ex)
// {
// return Json(new { Status = false, Message = "Error Occured" }, JsonRequestBehavior.AllowGet);
// }
//}
public ActionResult SaveProduct(POItemList product)
{
int id = 0;
PDService service = new PDService();
try
{
if (product.PIId > 0)
{
id = service.UpdatePOItem(product);
return(Json(new { Status = true, Id = id, Message = "Record updated successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
id = service.AddPOItem(product);
return(Json(new { Status = true, Id = id, Message = "Record added successfully" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { Status = false, Message = "Error Occured" }, JsonRequestBehavior.AllowGet));
}
}
