public static void AddUpdateUserAddress(AddressInfo addressObj, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFParamNoSCode(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("AddressID", addressObj.AddressID)); parameter.Add(new KeyValuePair <string, object>("FirstName", addressObj.FirstName)); parameter.Add(new KeyValuePair <string, object>("LastName", addressObj.LastName)); parameter.Add(new KeyValuePair <string, object>("Email", addressObj.Email)); parameter.Add(new KeyValuePair <string, object>("Company", addressObj.Company)); parameter.Add(new KeyValuePair <string, object>("Address1", addressObj.Address1)); parameter.Add(new KeyValuePair <string, object>("Address2", addressObj.Address2)); parameter.Add(new KeyValuePair <string, object>("City", addressObj.City)); parameter.Add(new KeyValuePair <string, object>("State", addressObj.State)); parameter.Add(new KeyValuePair <string, object>("Zip", addressObj.Zip)); parameter.Add(new KeyValuePair <string, object>("Phone", addressObj.Phone)); parameter.Add(new KeyValuePair <string, object>("Mobile", addressObj.Mobile)); parameter.Add(new KeyValuePair <string, object>("Fax", addressObj.Fax)); parameter.Add(new KeyValuePair <string, object>("WebSite", addressObj.Website)); parameter.Add(new KeyValuePair <string, object>("Country", addressObj.Country)); parameter.Add(new KeyValuePair <string, object>("IsDefaultShipping", addressObj.DefaultShipping)); parameter.Add(new KeyValuePair <string, object>("IsDefaultBilling", addressObj.DefaultBilling)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateUserAddress", parameter); }
public static List <AddressInfo> GetUserAddressDetails(AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFParamNoSCode(aspxCommonObj); SQLHandler sqlh = new SQLHandler(); List <AddressInfo> lstAddress = sqlh.ExecuteAsList <AddressInfo>("usp_Aspx_GetUserAddressBookDetails", parameter); return(lstAddress); }
public static string GetUserBillingEmail(int addressID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFParamNoSCode(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@AddressID", addressID)); SQLHandler sqlH = new SQLHandler(); string userEmail = sqlH.ExecuteAsScalar <string>("[usp_Aspx_GetUserBillingEmail]", parameter); return(userEmail); } catch (Exception e) { throw e; } }
//-----------------------UserDashBoard/ My Orders------------------- public static List <OrderItemsInfo> GetMyOrders(int orderID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFParamNoSCode(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("OrderID", orderID)); OracleHandler sqlh = new OracleHandler(); List <OrderItemsInfo> info = sqlh.ExecuteAsList <OrderItemsInfo>("usp_Aspx_GetMyOrders", parameter); return(info); } catch (Exception e) { throw e; } }
public static List <ReturnItemsInfo> GetMyReturnsDetails(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFParamNoSCode(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair <string, object>("OrderID", returnDetailObj.OrderID)); OracleHandler sqlh = new OracleHandler(); List <ReturnItemsInfo> info = sqlh.ExecuteAsList <ReturnItemsInfo>("usp_Aspx_GetMyReturnsDetails", parameter); return(info); } catch (Exception e) { throw e; } }