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;
}
}
