private void btnAddVendor_Click(object sender, RoutedEventArgs e) { VendorsModel model = new VendorsModel() { Address = txtAddress.Text, City = txtCity.Text, PhoneNumber = txtPhoneNumber.Text, State = txtState.Text, VendorName = txtName.Text, Website = txtWebsite.Text, ZipCode = txtZipCode.Text }; dbConnectt.AddVendor(model); txtAddress.Text = ""; txtCity.Text = ""; txtPhoneNumber.Text = ""; txtState.Text = ""; txtName.Text = ""; txtWebsite.Text = ""; txtZipCode.Text = ""; MessageBox.Show("Vendor added successfully"); }
public ActionResult Index(bool noLayout = false) { if (D2Cache == null || D2Cache.CacheExpired) { D2Cache = new VendorsModel() { XurInTower = XurManager.InTower(2), XurSales = XurManager.GetD2CurrentItems(), XurLocation = XurManager.GetD2CurrentLocation(), ExpiryTime = DateTime.Now.AddMinutes(30), StartTime = DateTime.Now }; } if (noLayout) { return(View("PartialIndex", D2Cache)); } else { ViewBag.HtmlTagOverride = @"data-redirect=""/#vendors"""; return(View("Index", D2Cache)); } }
public void UpdateVendor(VendorsModel vendorModel) { string connectionString = CreateDatabase(); DataTable dt = new DataTable(); using (SqlCeCommand comm = new SqlCeCommand()) { comm.Connection = new SqlCeConnection(connectionString); comm.CommandType = CommandType.Text; comm.CommandText = "UPDATE Vendors SET VendorName = @VendorName, Address = @Address, " + "City = @City, State = @State, ZipCode = @ZipCode, Phone = @Phone, WebSite = @Website " + "Where VendorId = @VendorId"; comm.Parameters.AddWithValue("@VendorId", vendorModel.VendorId); comm.Parameters.AddWithValue("@VendorName", vendorModel.VendorName); comm.Parameters.AddWithValue("@Address", vendorModel.Address); comm.Parameters.AddWithValue("@City", vendorModel.City); comm.Parameters.AddWithValue("@State", vendorModel.State); comm.Parameters.AddWithValue("@ZipCode", vendorModel.ZipCode); comm.Parameters.AddWithValue("@Phone", vendorModel.PhoneNumber); comm.Parameters.AddWithValue("@Website", vendorModel.Website); comm.Connection.Open(); comm.ExecuteNonQuery(); comm.Connection.Close(); } }
private void btnEditVendor_Click(object sender, RoutedEventArgs e) { VendorsModel vendorInfo = ((FrameworkElement)sender).DataContext as VendorsModel; EditVendor editVendor = new EditVendor(vendorInfo.VendorId); editVendor.Show(); this.Close(); }
/// <summary> /// Create new vendor. /// </summary> public static void SaveNewVendor(VendorsModel vendor) { var newVendor = new Vendor { Name = vendor.Name, Address = vendor.Address, Phone = vendor.Phone, Email = vendor.Email }; OimsDataContext.Add(newVendor); OimsDataContext.SaveChanges(); }
private void btnVendorProducst_Click(object sender, RoutedEventArgs e) { VendorsModel vendorInfo = ((FrameworkElement)sender).DataContext as VendorsModel; IEnumerable <VendorProductsModel> vendorProducts = dbConnect.GetVendorProducts(vendorInfo.VendorId); dgVendorProducts.Visibility = Visibility.Visible; lblVendorProducts.Visibility = Visibility.Visible; btnAddProduct.Visibility = Visibility.Visible; lblVendorProducts.Content = "Vendor Products for Vendor: " + vendorInfo.VendorName; lblVendorID.Content = vendorInfo.VendorId.ToString(); dgVendorProducts.ItemsSource = vendorProducts; }
/// <summary> /// Update vendor. /// </summary> public static void UpdateVendor(VendorsModel vendor) { var editVendor = GetEditableVendor(vendor.Name); if (editVendor == null) { return; } editVendor.Address = vendor.Address; editVendor.Email = vendor.Email; editVendor.Phone = vendor.Phone; OimsDataContext.SaveChanges(); }
public EditVendor(int vendorId) { InitializeComponent(); VendorsModel vendor = dbConnect.GetVendorById(vendorId); txtAddress.Text = vendor.Address; txtCity.Text = vendor.City; txtName.Text = vendor.VendorName; txtPhoneNumber.Text = vendor.PhoneNumber; txtState.Text = vendor.State; txtVendorId.Text = vendor.VendorId.ToString(); txtWebsite.Text = vendor.Website; txtZipCode.Text = vendor.ZipCode; }
private void btnUpdateVendor_Click(object sender, RoutedEventArgs e) { VendorsModel model = new VendorsModel() { Address = txtAddress.Text, City = txtCity.Text, PhoneNumber = txtPhoneNumber.Text, State = txtState.Text, VendorId = Convert.ToInt32(txtVendorId.Text), VendorName = txtName.Text, Website = txtWebsite.Text, ZipCode = txtZipCode.Text }; dbConnect.UpdateVendor(model); MessageBox.Show("Vendor Updated Successfully"); }
/// <summary> /// Check if vendor name is unique. /// </summary> /// <param name="model">VendorsModel object.</param> /// <param name="action">Action enum.</param> /// <returns></returns> public static bool IsUniqueVendor(VendorsModel model, Action action) { var unique = false; switch (action) { case Action.New: var vendor = Vendors.FirstOrDefault(v => v.Name.Equals(model.Name)); unique = vendor == null; break; case Action.Update: var nameRecord = Vendors.FirstOrDefault(v => v.Name.ToLower().Equals(model.Email.ToLower())); unique = nameRecord == null || nameRecord.Name.Equals(model.Name); break; } return(unique); }
/// <summary> /// Update row of grid. /// </summary> public ActionResult UpdateGridForVendors([ModelBinder(typeof(DevExpressEditorsBinder))] VendorsModel model) { try { if (VendorRepository.IsUniqueVendor(model, Action.Update)) { VendorRepository.UpdateVendor(model); } else { TempData["ErrorMessage"] = Supervisor.VErrorMsgVendorExist; } } catch (Exception exc) { TempData["ErrorMessage"] = exc.Message; Logger.LogError(exc, "Error while updating vendors from Supervisor zone"); } return(PartialView("Grid/_GridForVendors", VendorRepository.Vendors)); }
public void AddVendor(VendorsModel vendorModel) { string connectionString = CreateDatabase(); DataTable dt = new DataTable(); using (SqlCeCommand comm = new SqlCeCommand()) { comm.Connection = new SqlCeConnection(connectionString); comm.CommandType = CommandType.Text; comm.CommandText = "insert into Vendors (VendorName, Address, City, State, ZipCode, Phone, Website) values (@VendorName, @Address, @City, @State, @ZipCode, @Phone, @WebSite)"; comm.Parameters.AddWithValue("@VendorName", vendorModel.VendorName); comm.Parameters.AddWithValue("@Address", vendorModel.Address); comm.Parameters.AddWithValue("@City", vendorModel.City); comm.Parameters.AddWithValue("@State", vendorModel.State); comm.Parameters.AddWithValue("@ZipCode", vendorModel.ZipCode); comm.Parameters.AddWithValue("@Phone", vendorModel.PhoneNumber); comm.Parameters.AddWithValue("@Website", vendorModel.Website); comm.Connection.Open(); comm.ExecuteNonQuery(); comm.Connection.Close(); } }
public ActionResult VendorPost(VendorsModel model) { try { if (VendorRepository.IsUniqueVendor(model, Action.New)) { VendorRepository.SaveNewVendor(model); TempData["ConfirmMessage"] = string.Format(Common.ConfirmDiv, string.Format(Supervisor.VMsgVendorCreated, model.Name)); } else { TempData["ErrorMessage"] = string.Format(Common.ErrorDiv, Supervisor.VErrorMsgVendorExist); } } catch (Exception exc) { TempData["ErrorMessage"] = string.Format(Common.ErrorDiv, exc.Message); Logger.LogError(exc, "Error while saving new vendor from Supervisor zone"); } return(PartialView("_Result")); }
public ActionResult ItemsLog() { var model = new VendorsModel(); return(PartialView("_ItemsLog", model)); }