public bool UpdateCustomer(customer cu, address addr, animal an) { using (CalfScramblerEntities cs = new CalfScramblerEntities()) { var cust = cs.customers.Where(x => x.CUSTOMER_ID == cu.CUSTOMER_ID).FirstOrDefault(); cust.CUSTOMER_NUMBER = cu.CUSTOMER_NUMBER; cust.FIRST_NAME = cu.FIRST_NAME; cust.LAST_NAME = cu.LAST_NAME; cust.LAST_UPDATE_DATE = DateTime.Now; var address = cs.addresses.Where(x => x.ADDRESS_ID == addr.ADDRESS_ID).FirstOrDefault(); address.ADDRESS1 = addr.ADDRESS1; address.CITY = addr.CITY; address.COUNTRY = addr.COUNTRY; address.CREATED_BY = addr.CREATED_BY; address.CREATION_DATE = addr.CREATION_DATE; address.EMAIL = addr.EMAIL; address.EMAIL_SECOND = addr.EMAIL_SECOND; address.PHONE = addr.PHONE; address.POSTAL = addr.POSTAL; address.STATE = addr.STATE; address.STATUS = addr.STATUS; if (an.ANIMAL_ID == 0 && an.ANIMAL_TYPE != null) { if (an.ANIMAL_TYPE.Equals("Steer", StringComparison.InvariantCultureIgnoreCase)) { an.ANIMAL_NAME = "Calf Scrambler"; an.DATE_OF_BIRTH = new DateTime(1901, 1, 1); } cs.animals.Add(an); } cs.SaveChanges(); return(true); } }
public void SaveAnimal(animal animal) { using (CalfScramblerEntities cs = new CalfScramblerEntities()) { if (animal.ANIMAL_TYPE.Equals("Steer", StringComparison.InvariantCultureIgnoreCase)) { animal.ANIMAL_NAME = "Calf Scrambler"; animal.DATE_OF_BIRTH = new DateTime(1901, 1, 1); } cs.animals.Add(animal); } }