public virtual IList <MemberAddressInfo> GetMemberAddresss(QueryInfo Query) { int PageSize; int CurrentPage; IList <MemberAddressInfo> entitys = null; MemberAddressInfo entity = null; string SqlList, SqlField, SqlOrder, SqlParam, SqlTable; SqlDataReader RdrList = null; try { CurrentPage = Query.CurrentPage; PageSize = Query.PageSize; SqlTable = "Member_Address"; SqlField = "*"; SqlParam = DBHelper.GetSqlParam(Query.ParamInfos); SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos); SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize); RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.HasRows) { entitys = new List <MemberAddressInfo>(); while (RdrList.Read()) { entity = new MemberAddressInfo(); entity.Member_Address_ID = Tools.NullInt(RdrList["Member_Address_ID"]); entity.Member_Address_MemberID = Tools.NullInt(RdrList["Member_Address_MemberID"]); entity.Member_Address_Country = Tools.NullStr(RdrList["Member_Address_Country"]); entity.Member_Address_State = Tools.NullStr(RdrList["Member_Address_State"]); entity.Member_Address_City = Tools.NullStr(RdrList["Member_Address_City"]); entity.Member_Address_County = Tools.NullStr(RdrList["Member_Address_County"]); entity.Member_Address_StreetAddress = Tools.NullStr(RdrList["Member_Address_StreetAddress"]); entity.Member_Address_Zip = Tools.NullStr(RdrList["Member_Address_Zip"]); entity.Member_Address_Name = Tools.NullStr(RdrList["Member_Address_Name"]); entity.Member_Address_Phone_Countrycode = Tools.NullStr(RdrList["Member_Address_Phone_Countrycode"]); entity.Member_Address_Phone_Areacode = Tools.NullStr(RdrList["Member_Address_Phone_Areacode"]); entity.Member_Address_Phone_Number = Tools.NullStr(RdrList["Member_Address_Phone_Number"]); entity.Member_Address_Mobile = Tools.NullStr(RdrList["Member_Address_Mobile"]); entity.Member_Address_IsDefault = Tools.NullInt(RdrList["Member_Address_IsDefault"]); entity.Member_Address_Site = Tools.NullStr(RdrList["Member_Address_Site"]); entitys.Add(entity); entity = null; } } return(entitys); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public MemberInfo SaveCheckoutAddressInfo(MemberAddressInfo req) { var res = Call <MemberInfo, MemberAddressInfo>(req, MethodBase.GetCurrentMethod().Name); HttpContext.Current.Session["Member"] = res; return(res); }
public MemberAddressInfo GetMemberAddress(string id) { var a = Provider.Database.Read <MemberAddress>("Id={0}", id); if (a == null || a.MemberId != Session.MemberId) { throw new APIException(Provider.TR("No such address")); } var address = new MemberAddressInfo(); a.CopyPropertiesWithSameName(address); return(address); }
public MemberAddressInfo SaveMemberAddress(MemberAddressInfo req) { var a = Provider.Database.Read <MemberAddress>("Id = {0}", req.Id) ?? new MemberAddress(); req.CopyPropertiesWithSameName(a); a.MemberId = Session.MemberId; a.Save(); if (a.AddressType == AddressTypes.DefaultAddress) { Session.Member().MemberAddressId = a.Id; Session.Member().Save(); } return(a.ToEntityInfo <MemberAddressInfo>()); }
public static async Task setAddressInfo(this IServiceProvider sp) { var ds = sp.Resolve <IMemberAddressService>(); var memInfo = new MemberAddressInfo() { MemberAddress = "发货地址" + Strings.NumberAndLowerUpperChars.Random(4), MemberName = "发货人" + Strings.NumberAndLowerUpperChars.Random(4), MemberPhoneNum = "1888888" + Strings.Numbers.Random(4) }; await ds.SetMemberAddressInfo(memInfo); var oldName = await ds.GetMemberAddressInfo(); Assert.AreEqual(memInfo.MemberAddress, oldName.MemberAddress); Assert.AreEqual(memInfo.MemberName, oldName.MemberName); Assert.AreEqual(memInfo.MemberPhoneNum, oldName.MemberPhoneNum); }
public virtual bool EditMemberAddress(MemberAddressInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT * FROM Member_Address WHERE Member_Address_ID = " + entity.Member_Address_ID; DtAdd = DBHelper.Query(SqlAdd); try { if (DtAdd.Rows.Count > 0) { DrAdd = DtAdd.Rows[0]; DrAdd["Member_Address_ID"] = entity.Member_Address_ID; DrAdd["Member_Address_MemberID"] = entity.Member_Address_MemberID; DrAdd["Member_Address_Country"] = entity.Member_Address_Country; DrAdd["Member_Address_State"] = entity.Member_Address_State; DrAdd["Member_Address_City"] = entity.Member_Address_City; DrAdd["Member_Address_County"] = entity.Member_Address_County; DrAdd["Member_Address_StreetAddress"] = entity.Member_Address_StreetAddress; DrAdd["Member_Address_Zip"] = entity.Member_Address_Zip; DrAdd["Member_Address_Name"] = entity.Member_Address_Name; DrAdd["Member_Address_Phone_Countrycode"] = entity.Member_Address_Phone_Countrycode; DrAdd["Member_Address_Phone_Areacode"] = entity.Member_Address_Phone_Areacode; DrAdd["Member_Address_Phone_Number"] = entity.Member_Address_Phone_Number; DrAdd["Member_Address_Mobile"] = entity.Member_Address_Mobile; DrAdd["Member_Address_IsDefault"] = entity.Member_Address_IsDefault; DrAdd["Member_Address_Site"] = entity.Member_Address_Site; DBHelper.SaveChanges(SqlAdd, DtAdd); } else { return(false); } } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } return(true); }
public virtual MemberAddressInfo GetMemberAddressByID(int ID) { MemberAddressInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Member_Address WHERE Member_Address_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new MemberAddressInfo(); entity.Member_Address_ID = Tools.NullInt(RdrList["Member_Address_ID"]); entity.Member_Address_MemberID = Tools.NullInt(RdrList["Member_Address_MemberID"]); entity.Member_Address_Country = Tools.NullStr(RdrList["Member_Address_Country"]); entity.Member_Address_State = Tools.NullStr(RdrList["Member_Address_State"]); entity.Member_Address_City = Tools.NullStr(RdrList["Member_Address_City"]); entity.Member_Address_County = Tools.NullStr(RdrList["Member_Address_County"]); entity.Member_Address_StreetAddress = Tools.NullStr(RdrList["Member_Address_StreetAddress"]); entity.Member_Address_Zip = Tools.NullStr(RdrList["Member_Address_Zip"]); entity.Member_Address_Name = Tools.NullStr(RdrList["Member_Address_Name"]); entity.Member_Address_Phone_Countrycode = Tools.NullStr(RdrList["Member_Address_Phone_Countrycode"]); entity.Member_Address_Phone_Areacode = Tools.NullStr(RdrList["Member_Address_Phone_Areacode"]); entity.Member_Address_Phone_Number = Tools.NullStr(RdrList["Member_Address_Phone_Number"]); entity.Member_Address_Mobile = Tools.NullStr(RdrList["Member_Address_Mobile"]); entity.Member_Address_IsDefault = Tools.NullInt(RdrList["Member_Address_IsDefault"]); entity.Member_Address_Site = Tools.NullStr(RdrList["Member_Address_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual bool AddMemberAddress(MemberAddressInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT TOP 0 * FROM Member_Address"; DtAdd = DBHelper.Query(SqlAdd); DrAdd = DtAdd.NewRow(); DrAdd["Member_Address_ID"] = entity.Member_Address_ID; DrAdd["Member_Address_MemberID"] = entity.Member_Address_MemberID; DrAdd["Member_Address_Country"] = entity.Member_Address_Country; DrAdd["Member_Address_State"] = entity.Member_Address_State; DrAdd["Member_Address_City"] = entity.Member_Address_City; DrAdd["Member_Address_County"] = entity.Member_Address_County; DrAdd["Member_Address_StreetAddress"] = entity.Member_Address_StreetAddress; DrAdd["Member_Address_Zip"] = entity.Member_Address_Zip; DrAdd["Member_Address_Name"] = entity.Member_Address_Name; DrAdd["Member_Address_Phone_Countrycode"] = entity.Member_Address_Phone_Countrycode; DrAdd["Member_Address_Phone_Areacode"] = entity.Member_Address_Phone_Areacode; DrAdd["Member_Address_Phone_Number"] = entity.Member_Address_Phone_Number; DrAdd["Member_Address_Mobile"] = entity.Member_Address_Mobile; DrAdd["Member_Address_IsDefault"] = entity.Member_Address_IsDefault; DrAdd["Member_Address_Site"] = entity.Member_Address_Site; DtAdd.Rows.Add(DrAdd); try { DBHelper.SaveChanges(SqlAdd, DtAdd); return(true); } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } }
public virtual bool EditMemberAddress(MemberAddressInfo entity) { return(MyDAL.EditMemberAddress(entity)); }
public MemberAddressInfo SaveMemberAddress(MemberAddressInfo req) { return(Call <MemberAddressInfo, MemberAddressInfo>(req, MethodBase.GetCurrentMethod().Name)); }
public MemberInfo SaveCheckoutAddressInfo(MemberAddressInfo req) { // eğer yeni ziyaretçi ise if (string.IsNullOrWhiteSpace(this.Session.MemberId)) { if (!req.Email.IsEmail()) { throw new APIException("Invalid email address."); } // yeni üye kaydı oluşturalım Member m = Provider.Database.Read <Member>("Email={0}", req.Email); if (m != null) { throw new APIException("The email address is registered. Please login before proceeding.", ErrorTypes.ValidationError, ErrorCodes.ExistingMemberCannotSignUp); } m = new Member(); req.CopyPropertiesWithSameName(m); if (req.FullName.Contains(" ")) { while (req.FullName.Contains(" ")) { req.FullName = req.FullName.Replace(" ", " "); } m.FirstName = req.FullName.Substring(0, req.FullName.IndexOf(' ')); m.LastName = req.FullName.Substring(req.FullName.IndexOf(' ') + 1); } else { m.FirstName = req.FullName; } m.MemberType = MemberTypes.Individual; m.State = MemberStates.WaitingEmailConfirmation; m.ClientId = ApiClient.ClientId; m.Save(); // yeni üyeye email confirmation mesajı m.SendEmailWithPasswordAndConfirmationCode(); // adress kaydını oluşturalım MemberAddress ma = new MemberAddress(); req.CopyPropertiesWithSameName(ma); ma.InvoiceTitle = string.IsNullOrWhiteSpace(ma.InvoiceTitle) ? m.FullName : ma.InvoiceTitle; ma.MemberId = m.Id; ma.Save(); // bu adresi üyenin default adresi yapalım m.MemberAddressId = ma.Id; m.Save(); // sepetini üye kaydıyla ilişkilendirelim var order = Order.GetMemberBasket(); order.MemberAddressId = ma.Id; order.MemberId = m.Id; order.Save(); this.Session.MemberId = m.Id; this.Session.Save(); return(m.ToEntityInfo <MemberInfo>()); } // eğer oturum açılmışsa { // üyede eksik bilgi varsa tamamlayalım Member m = this.Session.Member(); if (string.IsNullOrWhiteSpace(m.FirstName)) // ismi eksikse ekleyelim { if (req.FullName != null && req.FullName.Contains(" ")) { while (req.FullName.Contains(" ")) { req.FullName = req.FullName.Replace(" ", " "); } m.FirstName = req.FullName.Substring(0, req.FullName.IndexOf(' ')); m.LastName = req.FullName.Substring(req.FullName.IndexOf(' ') + 1); } else { m.FirstName = req.FullName; } } if (string.IsNullOrWhiteSpace(m.CompanyInfo)) // firma adı eksikse ekleyelim { m.CompanyInfo = req.InvoiceTitle; } if (string.IsNullOrWhiteSpace(m.PhoneNumber)) // telefon no eksikse ekleyelim { m.PhoneNumber = req.PhoneNumber; } m.Save(); // gönderilen adresi insert ya da update edelim MemberAddress ma = Provider.Database.Read <MemberAddress>("Id={0}", req.Id) ?? new MemberAddress(); req.CopyPropertiesWithSameName(ma); ma.MemberId = m.Id; ma.Save(); // sepetini adresle ilişkilendirelim var order = Order.GetMemberBasket(); order.MemberAddressId = ma.Id; order.MemberId = Session.MemberId; order.Save(); return(m.ToEntityInfo <MemberInfo>()); } }