public int InsertCustomerItemRate(CustomerVsWorkDescriptionRate objCustomerVsWorkRate)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
int id = 0;
foreach (var item in objCustomerVsWorkRate.CustomerVsWorkRateItem)
{
string sql = @"insert into CustomerVsWorkRate(CustomerId,WorkDescriptionId,FixedRate,CreatedBy,CreatedDate,OrganizationId,isActive)
Values (@CustomerId,@WorkDescriptionId,@FixedRate,@CreatedBy,@CreatedDate,@OrganizationId,1);
SELECT CAST(SCOPE_IDENTITY() as int)";
//id = connection.Query<int>(sql, objOpeningStock).Single();
id = connection.Query <int>(sql, new
{
CustomerId = objCustomerVsWorkRate.CustomerId,
WorkDescriptionId = item.WorkDescriptionId,
FixedRate = item.FixedRate,
CreatedBy = objCustomerVsWorkRate.CreatedBy,
CreatedDate = objCustomerVsWorkRate.CreatedDate,
OrganizationId = objCustomerVsWorkRate.OrganizationId
}).Single();
InsertLoginHistory(dataConnection, objCustomerVsWorkRate.CreatedBy, "Update", "Customer Vs Work Rate", id.ToString(), "0");
}
return(id);
}
}
public int DeleteCustomerItemRate(CustomerVsWorkDescriptionRate objCustomerVsWorkRate)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"Delete From CustomerVsWorkRate WHERE CustomerId=@CustomerId";
var id = connection.Execute(sql, objCustomerVsWorkRate);
InsertLoginHistory(dataConnection, objCustomerVsWorkRate.CreatedBy, "Delete", "Customer Vs Work Rate", id.ToString(), "0");
return(id);
}
}
public ActionResult Create()
{
FillCustomer();
CustomerVsWorkDescriptionRate CustomerVsWorkDescriptionRate = new CustomerVsWorkDescriptionRate();
CustomerVsWorkDescriptionRate.CustomerVsWorkRateItem = new List <CustomerVsWorkRateItem>();
CustomerVsWorkDescriptionRate.CustomerVsWorkRateItem.Add(new CustomerVsWorkRateItem());
return(View(CustomerVsWorkDescriptionRate));
}
public ActionResult Save(CustomerVsWorkDescriptionRate model)
{
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
new CustomerVsWorkRateRepository().DeleteCustomerItemRate(model);
new CustomerVsWorkRateRepository().InsertCustomerItemRate(model);
FillCustomer();
CustomerVsWorkDescriptionRate CustomerVsWorkDescriptionRate = new CustomerVsWorkDescriptionRate();
CustomerVsWorkDescriptionRate.CustomerVsWorkRateItem = new List <CustomerVsWorkRateItem>();
CustomerVsWorkDescriptionRate.CustomerVsWorkRateItem.Add(new CustomerVsWorkRateItem());
TempData["Success"] = "Updated Successfully!";
//TempData["CustomerId"] = model.CustomerId;
return(RedirectToAction("Create"));
}
public ActionResult CustomerItemRateList(int?CustomerId)
{
CustomerVsWorkDescriptionRate CustomerVsWorkDescriptionRate = new CustomerVsWorkDescriptionRate();
CustomerVsWorkDescriptionRate.CustomerVsWorkRateItem = new List <CustomerVsWorkRateItem>();
var repo = new CustomerVsWorkRateRepository();
//if (CustomerId == null || CustomerId == 0)
//{
// CustomerVsWorkDescriptionRate.CustomerVsWorkRateItem = repo.GetWorkList().ToList();
//}
//else
//{
CustomerVsWorkDescriptionRate.CustomerVsWorkRateItem = repo.GetItem(CustomerId ?? 0).ToList();
//}
if (CustomerVsWorkDescriptionRate.CustomerVsWorkRateItem.Count == 0)
{
CustomerVsWorkDescriptionRate.CustomerVsWorkRateItem = repo.GetWorkList().ToList();
}
return(PartialView("CustomerItemRateList", CustomerVsWorkDescriptionRate));
}
