public dynamic UpdateService([FromBody] Service Modell) { try { Service findService = db.Services.Where(zz => zz.ServiceID == Modell.ServiceID).FirstOrDefault(); findService.Name = Modell.Name; findService.Description = Modell.Description; findService.Duration = Modell.Duration; findService.TypeID = Modell.TypeID; db.SaveChanges(); foreach (ServicePrice Items in Modell.ServicePrices) { ServicePrice findPrice = db.ServicePrices.Where(zz => zz.PriceID == Items.PriceID && zz.Price == Items.Price).FirstOrDefault(); if (findPrice == null) { ServicePrice PriceObject = new ServicePrice(); PriceObject.ServiceID = findService.ServiceID; PriceObject.OptionID = Items.OptionID; PriceObject.Price = Items.Price; PriceObject.Date = DateTime.Now; db.ServicePrices.Add(PriceObject); db.SaveChanges(); } } return("success"); } catch (Exception err) { return(err.Message); } }
private void LoopPrices(ListView lvCurrencies, long?countryId = null, long?countryRegionId = null) { foreach (ListViewDataItem item in lvCurrencies.Items) { long currencyId = long.Parse((item.FindControl <HiddenField>("HdfId")).Value); long? servicePriceId = item.FindControl <HiddenField>("HdfPriceId").Value.TryParse <long>(); decimal?price = (item.FindControl <TextBox>("TxtPrice")).Text.ParseToDecimal(); if (servicePriceId != null) { if (price != null) { ServicePrice servicePrice = shippingMethod.OriginalPrices.SingleOrDefault(p => p.Id == servicePriceId.Value); servicePrice.Value = price.Value; } else { shippingMethod.OriginalPrices.RemoveAll(p => p.Id == servicePriceId.Value); } } else { if (price != null) { shippingMethod.OriginalPrices.Add(countryId == null ? new ServicePrice(currencyId, price.Value) : new ServicePrice(currencyId, price.Value, countryId.Value, countryRegionId)); } } } }
public async Task <Response> Insert([FromForm] ServicePrice model) { Response _objResponse = new Response(); try { if (ModelState.IsValid) { model.CreatedDate = DateTime.Now; model.UpdatedDate = DateTime.Now; _context.Add(model); await _context.SaveChangesAsync(); _objResponse.Status = "Success"; _objResponse.Data = null; } else { _objResponse.Status = "Validation Error"; _objResponse.Data = null; } } catch (Exception ex) { _objResponse.Data = null; _objResponse.Status = ex.ToString(); Console.WriteLine("\nMessage ---\n{0}", ex.ToString()); Console.WriteLine("\nStackTrace ---\n{0}", ex.StackTrace); } return(_objResponse); }
public async Task <Response> Update(int id, [FromForm] ServicePrice model) { Response _objResponse = new Response(); try { if (id != model.ServicePriceId) { _objResponse.Status = "No record found"; _objResponse.Data = null; } else { model.UpdatedDate = DateTime.Now; _context.Entry(model).Property(x => x.CreatedDate).IsModified = false; _context.Entry(model).State = EntityState.Modified; await _context.SaveChangesAsync(); _objResponse.Status = "Success"; _objResponse.Data = null; } } catch (Exception ex) { _objResponse.Data = null; _objResponse.Status = ex.ToString(); Console.WriteLine("\nMessage ---\n{0}", ex.ToString()); Console.WriteLine("\nStackTrace ---\n{0}", ex.StackTrace); } return(_objResponse); }
public async Task <IActionResult> Edit(int id, [Bind("IdServicePrice,ServicePriceDescr,CtAmountHour,ClAmountHour,ServicePriceStatus")] ServicePrice servicePrice) { if (id != servicePrice.IdServicePrice) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(servicePrice); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ServicePriceExists(servicePrice.IdServicePrice)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(servicePrice)); }
public async Task <IActionResult> Create([Bind("IdServicePrice,ServicePriceDescr,CtAmountHour,ClAmountHour,ServicePriceStatus")] ServicePrice servicePrice) { if (ModelState.IsValid) { _context.Add(servicePrice); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(servicePrice)); }
protected void LvDefaultCurrencies_ItemDataBound(object sender, ListViewItemEventArgs e) { Currency currency = (Currency)(e.Item as ListViewDataItem).DataItem; ServicePrice servicePrice = shippingMethod.OriginalPrices.Get(currency.Id); if (servicePrice != null) { e.Item.FindControl <HiddenField>("HdfPriceId").Value = servicePrice.Id.ToString(); e.Item.FindControl <TextBox>("TxtPrice").Text = servicePrice.Value.ToString("0.####"); } }
protected void LvCurrencies_ItemDataBound(object sender, ListViewItemEventArgs e) { Currency currency = (Currency)(e.Item as ListViewDataItem).DataItem; //Write Currency name e.Item.FindControl <Label>("LblCurrencyName").Text = currency.Name; ServicePrice servicePrice = shippingMethod.OriginalPrices.Get(currency.Id, currentCountryId, currentCountryRegionId); if (servicePrice != null) { e.Item.FindControl <HiddenField>("HdfPriceId").Value = servicePrice.Id.ToString(); e.Item.FindControl <TextBox>("TxtPrice").Text = servicePrice.Value.ToString("0.####"); } }
//method used to save the service price public void SaveServicePrice(ServicePrice servicePrice) { if (servicePrice.IdServicePrice == 0) { context.ServicePrice.Add(servicePrice); } else { ServicePrice dbEntry = context.ServicePrice. FirstOrDefault(s => s.IdServicePrice == servicePrice.IdServicePrice); if (dbEntry != null) { dbEntry.ServicePriceDescr = servicePrice.ServicePriceDescr; dbEntry.CtAmountHour = servicePrice.CtAmountHour; dbEntry.ClAmountHour = servicePrice.ClAmountHour; dbEntry.ServicePriceStatus = servicePrice.ServicePriceStatus; } } context.SaveChanges(); }
private void dgvAddServiceChange_CellClick(object sender, DataGridViewCellEventArgs e) { try { //Delete Column if (dgvAddServiceChange.Columns[e.ColumnIndex] == clmbtnDelete) { btnUpdate.Visible = true; btnUpdate.Visible = false; ServiceID = Convert.ToInt32(dgvAddServiceChange.Rows[e.RowIndex].Cells[clmServiceID.Name].Value); DialogResult dr = MessageBox.Show("Are you sure want to Delete in this Service ?", "CONFIRMATION", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { Execute objExecute = new Execute(); SqlParameter[] param = new SqlParameter[] { Execute.AddParameter("@intServiceID", ServiceID), }; int NoOfRowsEffected = objExecute.Executes("spDeleteService", param, CommandType.StoredProcedure); if (NoOfRowsEffected < 0) { MessageBox.Show("Successfully DELETE !"); GridLoad(); btnSave.Visible = true; btnUpdate.Visible = false; } else { MessageBox.Show("Item DELETE Process Error !"); } } } //edit column // btnSave.Visible = false; // btnUpdate.Visible = true; if (dgvAddServiceChange.Columns[e.ColumnIndex] == clmbtnEdit) { decimal ServicePrice; ServiceID = Convert.ToInt32(dgvAddServiceChange.Rows[e.RowIndex].Cells[clmServiceID.Name].Value); { Execute objExecute = new Execute(); string Query = "[dbo].[spGetServiceToEdit]"; SqlParameter[] paramt = new SqlParameter[] { Execute.AddParameter("@intServiceID", ServiceID) }; DataSet ds = (DataSet)objExecute.Executes(Query, ReturnType.DataSet, paramt, CommandType.StoredProcedure); if (ds.Tables[0].Rows.Count > 0) { txtServiceDec.Text = ds.Tables[0].Rows[0]["vcServiceName"].ToString(); ServicePrice = Convert.ToDecimal(ds.Tables[0].Rows[0]["decPrice"].ToString()); txtPrice.Text = ServicePrice.ToString(); } btnSave.Visible = false; btnUpdate.Visible = true; } } } catch (Exception ex) { MessageBox.Show("Data Deleting Error"); Logger.LoggError(ex, "dgvAddServiceChange_CellClick"); } }
private dynamic SaveService(Service Modell) { dynamic toReturn = new ExpandoObject(); try { db.Configuration.ProxyCreationEnabled = false; //first Save the service information Service myObject = new Service(); myObject.Name = Modell.Name; myObject.Description = Modell.Description; myObject.Duration = Modell.Duration; myObject.TypeID = Modell.TypeID; db.Services.Add(myObject); db.SaveChanges(); //retrieve the service ID from the info that were just saved int ServiceID = db.Services.Where(zz => zz.Name == Modell.Name).Select(zz => zz.ServiceID).FirstOrDefault(); if (Modell.ServicePrices != null) { foreach (ServicePrice Items in Modell.ServicePrices) { //Save the Service price object ServicePrice PriceObject = new ServicePrice(); PriceObject.ServiceID = ServiceID; //PriceObject.OptionID = Items.OptionID; PriceObject.Price = Items.Price; PriceObject.Date = DateTime.Now; db.ServicePrices.Add(PriceObject); db.SaveChanges(); } } if (Modell.ServiceTypeOptions != null) { foreach (ServiceTypeOption Items in Modell.ServiceTypeOptions) { //saves the OptionID and ServiceID into bride entity ServiceTypeOption newObject = new ServiceTypeOption(); newObject.ServiceID = ServiceID; int OptionID = (int)Items.OptionID; newObject.OptionID = OptionID; db.ServiceTypeOptions.Add(newObject); db.SaveChanges(); foreach (ServicePrice PriceItem in Items.ServicePrices) { ServicePrice PriceObject = new ServicePrice(); PriceObject.ServiceID = ServiceID; PriceObject.OptionID = OptionID; PriceObject.Price = PriceItem.Price; PriceObject.Date = DateTime.Now; db.ServicePrices.Add(PriceObject); db.SaveChanges(); } } } toReturn.Message = "success"; toReturn.ServiceID = ServiceID; return(toReturn); } catch (Exception err) { return(err.Message); } }