public string NewPurchaseReq(List <Core.Domain.Purchase_Requisition.PurchaseRequisitionDetail> PurchaseItem, Core.Domain.Purchase_Requisition.PurchaseRequisition PurchaseHeader)
{
db = new SqlConnection(ConfigurationManager.ConnectionStrings["cnConsumption"].ConnectionString);
string sql;
//First Add Header
int ID = 0;
string NewPrNO = "PR-" + DateTime.Now.ToLongTimeString();
sql = " INSERT INTO TH_PurchaseRequisition(PRNo,PRDate,KitchenID,Remarks)VALUES ('" + NewPrNO + "',@PRDate,1,@Remarks) " +
"Select Cast(SCOPE_IDENTITY() AS int)";
try
{
ID = db.Query <int>(sql, new
{
PurchaseHeader.PRDate,
PurchaseHeader.Remarks
}).SingleOrDefault();
}
catch (Exception e)
{
if (e.Message.IndexOf("") > 0)
{
db.Close();
return("-1");
}
}
foreach (PurchaseRequisitionDetail obj in PurchaseItem)
{
sql = " Insert into TD_PurchaseRequisition (PRID,ItemID,Qty,Unit,Specs) " +
" Values (" + ID + ",@ItemID,@Qty,@Unit,@Specs)";
db.Execute(sql, new
{
obj.ItemId,
obj.Qty,
obj.Unit,
obj.Specs
});
}
return(NewPrNO);
}
public string EditPurchaseReq(List <Core.Domain.Purchase_Requisition.PurchaseRequisitionDetail> PurchaseItem, Core.Domain.Purchase_Requisition.PurchaseRequisition PurchaseHeader)
{
db = new SqlConnection(ConfigurationManager.ConnectionStrings["cnConsumption"].ConnectionString);
string sql;
foreach (PurchaseRequisitionDetail obj in PurchaseItem)
{
sql = " Insert into TD_PurchaseRequisition (PRID,ItemID,Qty) " +
" Values (@PRID,@ItemID,@Qty)";
db.Execute(sql, new
{
obj.PRID,
obj.ItemId,
obj.Qty
});
}
return("");
}