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