public ActionResult StandardRate()
{
StandardSellingRate Model = new StandardSellingRate();
Model.StandardSellingRateItems = new RateSettingsRepository().GetStandardRateData();
return(View(Model));
}
public int InsertStandardRate(StandardSellingRate model)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction txn = connection.BeginTransaction();
try
{
string checksql = @"DELETE from [StandardRate]";
connection.Query <int>(checksql, transaction: txn);
foreach (var item in model.StandardSellingRateItems)
{
string sql = @"INSERT INTO [dbo].[StandardRate]
([ItemId] ,[Rate] ) VALUES (@ItemId,@Rate)
SELECT CAST(SCOPE_IDENTITY() as int)";
int ObjStandardRate = connection.Query <int>(sql, item, txn).First();
}
}
catch (Exception)
{
txn.Rollback();
throw;
}
txn.Commit();
return(1);
}
}
public ActionResult StandardRate(StandardSellingRate Model)
{
var rtn = new RateSettingsRepository().InsertStandardRate(Model);
TempData["Success"] = "Added Successfully!";
return(RedirectToAction("Index"));
}
