public void SaveSfgId() { using (AHT_MainDataContext context = new AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString)) { try { SFG_CustomerNumber sfg = (from a in context.SFG_CustomerNumbers where a.cusID == this.cusID select a).Single(); sfg.SFGCustNum = this.SfgId.ToString(); context.SubmitChanges(); } catch { } } }
/// <summary> /// Creates member at AH from data returned by SFG, returns true if member already exists /// </summary> /// <param name="member"></param> /// <returns></returns> public static bool CreateMember(Member member) { using (SupportDataDataContext context = new SupportDataDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString)) { var customer = (from a in context.Customers where a.cusUserName == member.UserName select a).SingleOrDefault(); var sfglink = (from a in context.SFG_CustomerNumbers where a.SFGCustNum == member.MemberId select a).SingleOrDefault(); if (customer == null && sfglink != null) { //someone else already has that sfgid return(false); } try { if (customer == null) { AddressCustomer address = new AddressCustomer(); address.addAddress1 = member.Address.Address1; address.addAddress2 = member.Address.Address2; address.addAddress3 = member.Address.Address3; address.addCity = member.Address.City; address.addCountry = member.Address.Country; address.addDateCreated = DateTime.Now; address.addDateUpdated = DateTime.Now; address.addPostalCode = member.Address.PostalCode; address.addRegion = member.Address.State; context.AddressCustomers.InsertOnSubmit(address); context.SubmitChanges(); var custnum = (from a in context.Customers select a.cusCustNum).Max(); int nextcustnum = int.Parse(custnum) + 1; customer = new Customer(); customer.addID = address.addID; customer.cusCustNum = nextcustnum.ToString(); customer.cusFirstName = member.FirstName; customer.cusLastName = member.LastName; customer.cusCustType = "UNKNOWN"; customer.cusPriFirstName = member.FirstName; customer.cusPriLastName = member.LastName; customer.cusPrefix = member.Salutation; customer.cusSuffix = member.Suffix; customer.cusEmail = member.Email; customer.cusUserName = member.UserName; customer.cusIsCharterMem = false; customer.cusIsDeleted = false; customer.cusSex = 'U'; customer.cusHasDisplayName = true; customer.cusDisplayName = member.UserName; customer.cusGUID = Guid.NewGuid(); context.Customers.InsertOnSubmit(customer); context.SubmitChanges(); } if (sfglink == null) { sfglink = new SFG_CustomerNumber(); sfglink.SFGCustNum = member.MemberId; sfglink.cusID = customer.cusID; context.SFG_CustomerNumbers.InsertOnSubmit(sfglink); context.SubmitChanges(); } } catch { return(false); } } return(true); }
/// <summary> /// Creates member at AH from data returned by SFG, returns true if member already exists /// </summary> /// <param name="member"></param> /// <returns></returns> public static bool CreateMember(Member member) { using (SupportDataDataContext context = new SupportDataDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString)) { var customer = (from a in context.Customers where a.cusUserName == member.UserName select a).SingleOrDefault(); var sfglink = (from a in context.SFG_CustomerNumbers where a.SFGCustNum == member.MemberId select a).SingleOrDefault(); if (customer == null && sfglink != null) { //someone else already has that sfgid return false; } try { if (customer == null) { AddressCustomer address = new AddressCustomer(); address.addAddress1 = member.Address.Address1; address.addAddress2 = member.Address.Address2; address.addAddress3 = member.Address.Address3; address.addCity = member.Address.City; address.addCountry = member.Address.Country; address.addDateCreated = DateTime.Now; address.addDateUpdated = DateTime.Now; address.addPostalCode = member.Address.PostalCode; address.addRegion = member.Address.State; context.AddressCustomers.InsertOnSubmit(address); context.SubmitChanges(); var custnum = (from a in context.Customers select a.cusCustNum).Max(); int nextcustnum = int.Parse(custnum) + 1; customer = new Customer(); customer.addID = address.addID; customer.cusCustNum = nextcustnum.ToString(); customer.cusFirstName = member.FirstName; customer.cusLastName = member.LastName; customer.cusCustType = "UNKNOWN"; customer.cusPriFirstName = member.FirstName; customer.cusPriLastName = member.LastName; customer.cusPrefix = member.Salutation; customer.cusSuffix = member.Suffix; customer.cusEmail = member.Email; customer.cusUserName = member.UserName; customer.cusIsCharterMem = false; customer.cusIsDeleted = false; customer.cusSex = 'U'; customer.cusHasDisplayName = true; customer.cusDisplayName = member.UserName; customer.cusGUID = Guid.NewGuid(); context.Customers.InsertOnSubmit(customer); context.SubmitChanges(); } if (sfglink == null) { sfglink = new SFG_CustomerNumber(); sfglink.SFGCustNum = member.MemberId; sfglink.cusID = customer.cusID; context.SFG_CustomerNumbers.InsertOnSubmit(sfglink); context.SubmitChanges(); } } catch { return false; } } return true; }