private void SaveCustomerToDb(PetfirstCustomer mCustomer, wsQCustomer dbCustomer, bool bAdd) { dbCustomer.BillCity = mCustomer.BillingInfo.City; dbCustomer.BillFirstName = mCustomer.BillingInfo.FirstName; dbCustomer.BillLastName = mCustomer.BillingInfo.LastName; dbCustomer.BillState = mCustomer.BillingInfo.State; dbCustomer.BillStateId = mCustomer.BillingInfo.StateId; dbCustomer.BillStreetAddress = mCustomer.BillingInfo.Address1; dbCustomer.BillStreetAddress2 = mCustomer.BillingInfo.Address2; dbCustomer.BillZipcode = mCustomer.BillingInfo.Zip; dbCustomer.City = mCustomer.MembershipInfo.City; dbCustomer.FirstName = mCustomer.MembershipInfo.FirstName; dbCustomer.LastName = mCustomer.MembershipInfo.LastName; dbCustomer.State = mCustomer.MembershipInfo.State; dbCustomer.StateId = mCustomer.MembershipInfo.StateId; dbCustomer.StreetAddress = mCustomer.MembershipInfo.Address1; dbCustomer.StreetAddress2 = mCustomer.MembershipInfo.Address2; dbCustomer.Zipcode = mCustomer.MembershipInfo.Zip; dbCustomer.Email = mCustomer.MembershipInfo.Email; dbCustomer.EnrollmentCode = mCustomer.EnrollmentCode; dbCustomer.Phone = mCustomer.MembershipInfo.Phone; dbCustomer.PaymentFrequency = mCustomer.PayFrequency; if (!bAdd) dbCustomer.ModifyDate = DateTime.Now; else context.wsQCustomers.AddObject(dbCustomer); context.SaveChanges(); if (mCustomer.CustomerId == 0) mCustomer.CustomerId = dbCustomer.QCustomerID; }
/// <summary> /// Deprecated Method for adding a new object to the wsQCustomers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTowsQCustomers(wsQCustomer wsQCustomer) { base.AddObject("wsQCustomers", wsQCustomer); }
public void SaveCustomer(PetfirstCustomer mCustomer) { wsQCustomer dbCustomer = null; bool bAdd = false; dbCustomer = GetCustomerByEmailZip(mCustomer.MembershipInfo.Email, mCustomer.MembershipInfo.Zip);//tries to get by email and zip if (dbCustomer == null) { if (mCustomer.CustomerId==0) { dbCustomer = new wsQCustomer(); bAdd = true; dbCustomer.CreateDate = DateTime.Now; } else dbCustomer = GetCustomerById(mCustomer.CustomerId); } else { mCustomer.OldCustData = true;//customer saved in db mCustomer.CustomerId = dbCustomer.QCustomerID; } if (dbCustomer == null) { dbCustomer = new wsQCustomer(); bAdd = true; dbCustomer.CreateDate = DateTime.Now; SaveCustomerToDb(mCustomer, dbCustomer, bAdd); } else { SaveCustomerToDb(mCustomer, dbCustomer, bAdd); } }
/// <summary> /// Create a new wsQCustomer object. /// </summary> /// <param name="qCustomerID">Initial value of the QCustomerID property.</param> /// <param name="enrollmentCode">Initial value of the EnrollmentCode property.</param> /// <param name="email">Initial value of the Email property.</param> /// <param name="createDate">Initial value of the CreateDate property.</param> public static wsQCustomer CreatewsQCustomer(global::System.Int32 qCustomerID, global::System.String enrollmentCode, global::System.String email, global::System.DateTime createDate) { wsQCustomer wsQCustomer = new wsQCustomer(); wsQCustomer.QCustomerID = qCustomerID; wsQCustomer.EnrollmentCode = enrollmentCode; wsQCustomer.Email = email; wsQCustomer.CreateDate = createDate; return wsQCustomer; }