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")); }