public int UpdatePurchaseReturnByInvoice(Services.PurchaseItem.PurchaseReturnViewModel model)
{
db = new SqlConnection(ConfigurationManager.ConnectionStrings["cnConsumption"].ConnectionString);
string sql;
//First Add Header
int ID = 0;
sql = " INSERT INTO TH_PurchaseReturn(PurchaseId,SupplierID,RDate,KitchenID,ReturnBy)VALUES (@PurchaseID,@SupplierID,@returnDate,1,@ReturnBy) " +
"Select Cast(SCOPE_IDENTITY() AS int)";
try
{
ID = db.Query <int>(sql, new
{
model.PurchaseReturnItem[0].PurchaseID,
model.returnDate,
model.obj.SupplierID,
model.ReturnBy
}).SingleOrDefault();
}
catch (Exception e)
{
if (e.Message.IndexOf("") > 0)
{
db.Close();
return(0);
}
}
foreach (PurchaseReturnItem objDetail in model.PurchaseReturnItem)
{
if (objDetail.ReturnQty > 0)
{
sql = " Insert into TD_PurchaseReturn (ReturnID,ItemID,Quantity,Rate) " +
" Values (" + ID + ",@ItemID,@ReturnQty,@Rate)";
db.Execute(sql, new
{
objDetail.itemID,
objDetail.ReturnQty,
objDetail.Rate
});
}
}
db.Close();
return(ID);
}
public int UpdatePurchaseReturnByInvoice(Services.PurchaseItem.PurchaseReturnViewModel model)
{
PurchaseRepository IRepository = new PurchaseRepository();
return(IRepository.UpdatePurchaseReturnByInvoice(model));
}
