public void unsetOldRate(RateDataModel rate)
{
using (Conn)
{
string query = @"UPDATE Rates SET ExpiryDate = @ExpiryDate, IsActive = @IsActive WHERE Prod_Type_ID = @Prod_Type_ID";
Conn.Execute(query, new { ExpiryDate = DateTime.Now, IsActive = false, Prod_Type_ID = rate.Prod_Type_ID });
}
}
public void updateRate(RateDataModel ratedata)
{
RateModel rate = new RateModel();
adminDao.unsetOldRate(ratedata);
rate.Prod_Type_ID = ratedata.Prod_Type_ID;
rate.Rate = ratedata.Rate;
rate.EntryDate = DateTime.Now;
rate.IsActive = true;
adminDao.setRate(rate);
}
public RateListView()
{
InitializeComponent();
reader.Read();
rates = reader.Rates;
foreach (Rate rate in rates)
{
dataModel = new RateDataModel(rate);
dataModels.Add(dataModel);
}
viewModel = new RateListViewModel(this, dataModels);
DataContext = viewModel;
RunWorker();
}
private void WorkerDoWork(object sender, DoWorkEventArgs e)
{
while (true)
{
reader.Read();
rates = reader.Rates;
dataModels = new List<RateDataModel>();
foreach (Rate rate in rates)
{
dataModel = new RateDataModel(rate);
dataModels.Add(dataModel);
}
viewModel.Rates = dataModels;
Thread.Sleep(20000);
}
}
public HttpResponseMessage UpdateRate(RateDataModel data)
{
adminManager.updateRate(data);
return(Request.CreateErrorResponse(HttpStatusCode.OK, "Rate Updated Successfully"));
}
