public int InsertSupplierItemRate(SupplierItemRate objSupplierItemRate)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
int id = 0;
foreach (var item in objSupplierItemRate.SupplierItemRateItem)
{
string sql = @"insert into SupplierItemRate(SupplierId,ItemId,FixedRate,EffectiveDate,CreatedBy,CreatedDate,OrganizationId,isActive)
Values (@SupplierId,@ItemId,@FixedRate,@CreatedDate,@CreatedBy,@CreatedDate,@OrganizationId,1);
SELECT CAST(SCOPE_IDENTITY() as int)";
//id = connection.Query<int>(sql, objOpeningStock).Single();
id = connection.Query <int>(sql, new
{
SupplierId = objSupplierItemRate.SupplierId,
ItemId = item.ItemId,
FixedRate = item.FixedRate,
CreatedBy = objSupplierItemRate.CreatedBy,
EffectiveDate = objSupplierItemRate.CreatedDate,
CreatedDate = objSupplierItemRate.CreatedDate,
OrganizationId = objSupplierItemRate.OrganizationId
}).Single();
}
return(id);
}
}
public int DeleteSupplierItemRate(SupplierItemRate objSupplierItemRate)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"Delete From SupplierItemRate WHERE SupplierId=@SupplierId";
var id = connection.Execute(sql, objSupplierItemRate);
return(id);
}
}
public ActionResult Create()
{
FillSupplier();
SupplierItemRate SupplierItemRate = new SupplierItemRate();
SupplierItemRate.SupplierItemRateItem = new List <SupplierItemRateItem>();
SupplierItemRate.SupplierItemRateItem.Add(new SupplierItemRateItem());
return(View(SupplierItemRate));
}
public ActionResult Save(SupplierItemRate model)
{
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
new SupplierItemRateRepository().DeleteSupplierItemRate(model);
new SupplierItemRateRepository().InsertSupplierItemRate(model);
FillSupplier();
FillItem();
SupplierItemRate SupplierItemRate = new SupplierItemRate();
SupplierItemRate.SupplierItemRateItem = new List <SupplierItemRateItem>();
SupplierItemRate.SupplierItemRateItem.Add(new SupplierItemRateItem());
//return View("Create");
TempData["Success"] = "Updated Successfully!";
TempData["SupplierId"] = model.SupplierId;
return(RedirectToAction("Create"));
}
public ActionResult SupplierItemRateList(int?SupplierId)
{
FillItem();
SupplierItemRate SupplierItemRate = new SupplierItemRate();
SupplierItemRate.SupplierItemRateItem = new List <SupplierItemRateItem>();
if (SupplierId == null || SupplierId == 0)
{
var SupplierItemRateItem = new SupplierItemRateItem();
SupplierItemRate.SupplierItemRateItem.Add(SupplierItemRateItem);
}
else
{
var repo = new SupplierItemRateRepository();
SupplierItemRate.SupplierItemRateItem = repo.GetItem(SupplierId).ToList();
}
if (SupplierItemRate.SupplierItemRateItem.Count == 0)
{
SupplierItemRate.SupplierItemRateItem.Add(new SupplierItemRateItem());
}
return(PartialView("SupplierItemRateList", SupplierItemRate));
}
