public GRNItemList GetGRNItem(int?GIId)
{
PetaPoco.Database db = null;
var dbConn = DataContext.Database.Connection;
GRNItemList user = new GRNItemList();
try
{
using (DataContext)
{
dbConn.Open();
db = new PetaPoco.Database(dbConn);
db.EnableAutoSelect = false;
user = db.Query <GRNItemList>("exec usp_GetGRNItem " + "@GIId",
new { GIId = GIId }).FirstOrDefault();
dbConn.Close();
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (dbConn != null)
{
dbConn.Close();
}
}
return(user);
}
public JsonResult GetRMItemsDetails(int?GIId)
{
StoreService service = new StoreService();
GRNItemList user = new GRNItemList();
user = service.GetGRNItem(GIId);
return(Json(new { up = user.GIUnitPrice, pq = user.GIPendingQuantity, qty = user.GIReceivedQuantity, }, JsonRequestBehavior.AllowGet));
}
public ActionResult QRGenaration(int?GIId)
{
StoreService service = new StoreService();
QR qr = new QR();
GRNItemList gi = new GRNItemList();
gi = service.GetGRNItem(GIId);
qr.GIId = GIId;
qr.GRNId = gi.GRNId;
qr.PONo = gi.PONo;
qr.GIReceivedQuantity = gi.GIReceivedQuantity;
return(View("QRGenaration", qr));
}
public ActionResult AddGRNItem(int?GIId)
{
StoreService service = new StoreService();
GRNItemList Product = new GRNItemList();
ViewBag.Purchase = new SelectList(AllPOs(), "Value", "Text");
if (GIId != null)
{
Product = service.GetGRNItem(GIId);
}
ViewBag.PIItem = new SelectList(AllPOItem(Product.POId), "Value", "Text");
return(PartialView("_AddGRNItem", Product));
}
public int UpdateGRNItem(GRNItemList user)
{
int id = 0;
try
{
id = _repository.UpdateGRNItem(user);
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public GRNItemList GetGRNItem(int?GIId)
{
GRNItemList user = new GRNItemList();
try
{
user = _repository.GetGRNItem(GIId);
}
catch (Exception ex)
{
throw;
}
return(user);
}
public ActionResult SaveGRNItem(GRNItemList product)
{
int id = 0;
StoreService service = new StoreService();
try
{
if (product.GIId > 0)
{
id = service.UpdateGRNItem(product);
return(Json(new { Status = true, Id = id, Message = "Record updated successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
id = service.AddGRNItem(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));
}
}
public int AddGRNItem(GRNItemList 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_AddGRNItem " + " @POId,@GRNId,@PIId,@GIDescription,@GIReceivedQuantity,@GIUnitPrice; select @@ret;",
new
{
@POId = user.POId,
@GRNId = user.GRNId,
@PIId = user.PIId,
@GIDescription = user.GIDescription,
@GIReceivedQuantity = user.GIReceivedQuantity,
@GIUnitPrice = user.GIUnitPrice
});
}
catch (Exception ex)
{
}
finally
{
if (dbConn != null)
{
dbConn.Close();
}
}
return(id);
}
