public Boolean DeactivateTerm(ShippingTerm shippingTerm) { if (shippingTerm == null) { throw new ArgumentException("The shipping term was null, therefore it cannot be set to inactive."); } return(ShippingTermDAL.DeactivateTerm(shippingTerm, _connection)); }
public async Task <ActionResult> DeleteConfirmed(int id) { ShippingTerm shippingterm = await db.ShippingTerm.FindAsync(id); db.ShippingTerm.Remove(shippingterm); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
}//end GetShippingTermsById public static List <ShippingTerm> GetAllShippingTerms(SqlConnection myConnection) { var shippingTermList = new List <ShippingTerm>(); myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_GetAllShippingTerms", myConnection) { CommandType = CommandType.StoredProcedure }; myConnection.Open(); var mySqlReader = mySqlCommand.ExecuteReader(); if (mySqlReader.HasRows) { while (mySqlReader.Read()) { var shippingTerm = new ShippingTerm(mySqlReader.GetInt32(0)) { ShippingVendorId = mySqlReader.GetInt32(1), Description = mySqlReader.GetString(2), ShippingVendorName = mySqlReader.GetString(3), Active = mySqlReader.GetBoolean(4) }; //Add item to list shippingTermList.Add(shippingTerm); } } mySqlReader.Close(); } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { myConnection.Close(); } return(shippingTermList); }//end GetAllShippingTerms
public async Task <ActionResult> Edit([Bind(Include = "ShippingTermID,Updated,Updator,ShippingTermName,ShippingTermDescription")] ShippingTerm shippingterm) { if (ModelState.IsValid) { db.Entry(shippingterm).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(shippingterm)); }
}// end UpdateShippingTerms public static ShippingTerm GetShippingTermsById(int id, SqlConnection myConnection) { var shippingTerm = new ShippingTerm(); myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_GetShippingTermsByID", myConnection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@shippingTermID", id); myConnection.Open(); var mySqlReader = mySqlCommand.ExecuteReader(); if (mySqlReader.HasRows) { while (mySqlReader.Read()) { shippingTerm = new ShippingTerm(mySqlReader.GetInt32(0)) { ShippingVendorId = mySqlReader.GetInt32(1), Description = mySqlReader.GetString(2), ShippingVendorName = mySqlReader.GetString(3), Active = mySqlReader.GetBoolean(10) }; } } mySqlReader.Close(); } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { myConnection.Close(); } return(shippingTerm); }//end GetShippingTermsById
public async Task <ActionResult> Create([Bind(Include = "ShippingTermID,Updated,Updator,ShippingTermName,ShippingTermDescription")] ShippingTerm shippingterm) { if (ModelState.IsValid) { db.ShippingTerm.Add(shippingterm); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(shippingterm)); }
public FrmUpdateShippingTerm(ShippingTerm term, AccessToken _myAccessToken) { InitializeComponent(); var RoleAccess = new RoleAccess(_myAccessToken, this); _myShippingTermManager = new ShippingTermManager(); _myShippingVendorManager = new ShippingVendorManager(); vendors = _myShippingVendorManager.GetVendors(); _originalTerm = term; PopulateVendorCombo(); txtDesc.Text = term.Description; this.Text = "Shipping Term: " + term.Id; }//End of FrmUpdateShippingTerm(.)
// GET: /ShippingTerm/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ShippingTerm shippingterm = await db.ShippingTerm.FindAsync(id); if (shippingterm == null) { return(HttpNotFound()); } return(View(shippingterm)); }
protected override void OnDeleteToolBarItem() { if (MessageBoxService.AskForDelete(_activeShippingTerm.Title) == true) { using (var dbContext = new FarnahadManufacturingDbContext()) { var shippingTerm = dbContext.ShippingTerms.Find(_activeShippingTerm.Id); dbContext.ShippingTerms.Remove(shippingTerm); dbContext.SaveChanges(); } LoadSearchGridControl(); _activeShippingTerm = new ShippingTerm(); IsNotEditingAndAdding(); } }
public void SetUp() { this.shippingTermId = 145; this.shippingTerm = new ShippingTerm { Id = this.shippingTermId }; this.ShippingTermFacadeService.GetById(this.shippingTermId) .Returns(new SuccessResult <ShippingTerm>(this.shippingTerm)); this.Response = this.Browser.Get( $"/logistics/shipping-terms/{this.shippingTermId}", with => { with.Header("Accept", "application/json"); }).Result; }
}//End of btnUpdateTerm_Click(..) private void lvShippingTerms_Click_1(object sender, EventArgs e) { int currentIndex = this.lvShippingTerms.SelectedItems[0].Index; ShippingTerm thisTerm = _myTermManager.ShippingTerms[currentIndex]; if (thisTerm.Active == true) { btnActivateTerm.Enabled = false; btnDeactivateTerm.Enabled = true; } else { btnActivateTerm.Enabled = true; btnDeleteTerm.Enabled = true; btnDeactivateTerm.Enabled = false; } btnUpdateTerm.Enabled = true; }
public void SetUp() { this.shippingTerm1 = new ShippingTerm { Id = 1 }; this.shippingTerm2 = new ShippingTerm { Id = 2 }; this.ShippingTermFacadeService.GetAll().Returns( new SuccessResult <IEnumerable <ShippingTerm> >( new List <ShippingTerm> { this.shippingTerm1, this.shippingTerm2 })); this.Response = this.Browser.Get( "/logistics/shipping-terms", with => { with.Header("Accept", "application/json"); }).Result; }
public static Boolean DeleteTerm(ShippingTerm term, SqlConnection connection) { //?? Null-coalescing operator. //If the connection is null a new connection will be returned. SqlConnection conn = connection ?? GetInventoryDbConnection(); try { //Establishes the connection. conn.Open(); //Creates the command object, passing the SP and connection object. SqlCommand sqlCmd = new SqlCommand("proc_DeleteTerm", conn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@Id", term.Id); sqlCmd.Parameters.AddWithValue("@ShippingVendorId", term.ShippingVendorId); sqlCmd.Parameters.AddWithValue("@Active", term.Active); //If the procedure returns 1 set to true, if 0 remain false. if (sqlCmd.ExecuteNonQuery() == 1) { return(true); } } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { conn.Close(); } return(false); }
}//end AddShippingTerm public static bool UpdateShippingTerms(ShippingTerm shippingTerm, ShippingTerm origShippingTerm, SqlConnection myConnection) { myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_UpdateShippingTerm", myConnection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@shippingVendorID", shippingTerm.ShippingVendorId); mySqlCommand.Parameters.AddWithValue("@description", shippingTerm.Description); mySqlCommand.Parameters.AddWithValue("@orig_ShippingTermID", origShippingTerm.Id); mySqlCommand.Parameters.AddWithValue("@orig_ShippingVendorID", origShippingTerm.ShippingVendorId); mySqlCommand.Parameters.AddWithValue("@orig_Description", origShippingTerm.Description); myConnection.Open(); if (mySqlCommand.ExecuteNonQuery() == 1) { return(true); } } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { myConnection.Close(); } return(false); }// end UpdateShippingTerms
public void SetUp() { this.code = "Q.D"; this.shippingTerm = new ShippingTerm { Id = 1, Code = this.code }; this.ShippingTermFacadeService.Search(this.code) .Returns(new SuccessResult <IEnumerable <ShippingTerm> >(new List <ShippingTerm> { this.shippingTerm })); this.Response = this.Browser.Get( $"/logistics/shipping-terms/", with => { with.Header("Accept", "application/json"); with.Query("searchTerm", this.code); }).Result; }
}//End of btnCancel_Click(..) private void btnEdit_Click_1(object sender, EventArgs e) { ShippingTerm term; bool validShippingTerm = true; string errorMessage = "Please correct the following errors:\n"; if (Validation.IsNullOrEmpty(txtDesc.Text) || Validation.IsBlank(txtDesc.Text)) { validShippingTerm = false; errorMessage += "You must enter a description."; txtDesc.Focus(); } if (txtDesc.TextLength > 250) { validShippingTerm = false; errorMessage += "The description must be 250 characters or less."; txtDesc.Focus(); } if (validShippingTerm) { term = new ShippingTerm() { Description = txtDesc.Text, ShippingVendorId = ((KeyValuePair <int, string>)comboVendors.SelectedItem).Key, Id = _originalTerm.Id }; if (_myShippingTermManager.Update(term, _originalTerm)) { this.DialogResult = DialogResult.OK; MessageBox.Show("Shipping term " + _originalTerm.Id + " was updated."); } else { MessageBox.Show("The shipping term was not updated."); } } else { MessageBox.Show(errorMessage); } }//End of btnEdit_Click(..)
public ActionResult CreateEdit(ShippingTerm entity) { // TODO: Add insert logic here using (var context = new SCMSEntities()) { entity.CountryProgrammeId = countryProg.Id; if (entity.Id.Equals(Guid.Empty)) { entity.Id = Guid.NewGuid(); context.ShippingTerms.Add(entity); } else { entity.CountryProgrammeId = countryProg.Id; context.ShippingTerms.Attach(entity); ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(entity, System.Data.EntityState.Modified); } context.SaveChanges(); } return(ListView()); }
public Shipment CreateShipment(DateTime shipDate, string trackingNo, ShippingTerm term = null) { if (term == null) { term = ShippingTerm; } if (Shipments == null) { Shipments = new HashSet <Shipment>(); } var shipment = new Shipment() { Id = Guid.NewGuid(), ShipDate = shipDate, TrackingNo = trackingNo, Weight = 0, Status = ShipmentStatus.Prepare, }; Shipments.Add(shipment); return(shipment); }
}//End of ShippingTerm sets/gets. public bool Insert(ShippingTerm term) { //Need to do error checking. return(ShippingTermDAL.AddShippingTerm(term, _connection)); }//End of Insert(.)
private void EditData(ShippingTerm shippingTerm) { _activeShippingTerm = shippingTerm; FillData(_activeShippingTerm); IsEditing(); }
private void FillData(ShippingTerm shippingTerm) { NameTextEdit.Text = shippingTerm.Title; DescriptionTextEdit.Text = shippingTerm.Description; }
private void ReadData(ShippingTerm shippingTerm) { shippingTerm.Title = NameTextEdit.Text; shippingTerm.Description = DescriptionTextEdit.Text; }
protected override void OnAddToolBarItem() { _activeShippingTerm = new ShippingTerm(); FillData(_activeShippingTerm); IsAdding(); }
}//End of Insert(.) public bool Update(ShippingTerm term, ShippingTerm originalTerm) { //Need to do error checking. return(ShippingTermDAL.UpdateShippingTerms(term, originalTerm, _connection)); }//End of Update(..)
public ShippingTerm CreateNew(ShippingTerm term) { term.Id = Guid.NewGuid(); erpNodeDBContext.ShippingTerms.Add(term); return(term); }
}//End of Update(..) public ShippingTerm GetTermById(int termId) { //Need to do error checking. ShippingTerm = ShippingTermDAL.GetShippingTermsById(termId, _connection); return(ShippingTerm); }//End of GetTermById(.)