protected void LoadAddress(int id)
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(cnnString))
{
conn.Open();
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Cust", id, 0, System.Data.SqlDbType.Int, System.Data.ParameterDirection.Input));
dt = SqlJacknife.GetDataTable("Address_By_IDCust", parms);
if (dt.Rows.Count != 0)
{
if (dt.Rows[0]["country"].ToString() == "United States" || dt.Rows[0]["country"].ToString() == "USA")
{
country.SelectedIndex = 0;
}
else if (dt.Rows[0]["country"].ToString() == "Canada")
{
country.SelectedIndex = 1;
}
else
{
country.SelectedIndex = 2;
}
zip.Text = dt.Rows[0]["zip"].ToString();
sOrP.Text = dt.Rows[0]["state"].ToString();
address.Text = dt.Rows[0]["street"].ToString();
city.Text = dt.Rows[0]["city"].ToString();
changeRegex(null, null);
}
}
}
protected void loadCustomer(int id)
{
try
{
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Cust", id, 20, SqlDbType.Int, ParameterDirection.Input));
DataTable dt = SqlJacknife.GetDataTable("Get_Customer", parms);
lblId.Text = "Id :" + dt.Rows[0]["ID_Cust"].ToString();
fname.Text = dt.Rows[0]["FName"].ToString();
mname.Text = dt.Rows[0]["MName"].ToString();
lname.Text = dt.Rows[0]["LName"].ToString();
username.Text = dt.Rows[0]["UserName"].ToString();
birthDate.Value = dt.Rows[0]["DOB"].ToString().Split(' ')[0];
phone.Text = dt.Rows[0]["Phone"].ToString();
email.Text = dt.Rows[0]["Email"].ToString();
address.Text = dt.Rows[0]["Street"].ToString();
city.Text = dt.Rows[0]["City"].ToString();
sOrP.Text = dt.Rows[0]["State"].ToString();
zip.Text = dt.Rows[0]["ZIP"].ToString();
country.Text = dt.Rows[0]["Country"].ToString();
password.Text = dt.Rows[0]["Password"].ToString();
}
catch (Exception ex)
{
master.messageLoggedError(ex.Message);
IdeaHeaderAndSide.logMessage("IdeaShop-Account Editor: Retrieving customer data", ex.Message);
}
}
public void LoadUpAccount(int Id)
{
try
{
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Cust", Id, 0, SqlDbType.Int, ParameterDirection.Input));
DataTable dt = SqlJacknife.GetDataTable("RetrieveAccountByID", parms);
lblID.Text = Id.ToString();
username.Text = dt.Rows[0]["username"].ToString();
password.Text = dt.Rows[0]["password"].ToString();
fname.Text = dt.Rows[0]["fname"].ToString();
lname.Text = dt.Rows[0]["lname"].ToString();
birthDate.Value = dt.Rows[0]["dob"].ToString().Split(' ')[0];
mname.Text = dt.Rows[0]["mname"].ToString();
phone.Text = dt.Rows[0]["phone"].ToString();
email.Text = dt.Rows[0]["email"].ToString();
country.SelectedValue = dt.Rows[0]["country"].ToString();
city.Text = dt.Rows[0]["city"].ToString();
sOrP.Text = dt.Rows[0]["state"].ToString();
address.Text = dt.Rows[0]["street"].ToString();
zip.Text = dt.Rows[0]["zip"].ToString();
}
catch (Exception x)
{
master.messageLoggedError(x.Message);
IdeaHeaderAndSide.logMessage("AccountEditorInfoLoad", x.Message);
}
}
/// <summary>
/// Loads a single image
/// </summary>
/// <param name="ID_Img"></param>
/// <returns>A (hopefully) one-row DataTable</returns>
public DataTable Load_Image(int ID_Img)
{
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Img", ID_Img, 0, SqlDbType.Int, ParameterDirection.Input));
return(SqlJacknife.GetDataTable("Load_Image", parms));
}
private void LoadCart()
{
if (String.IsNullOrEmpty(Request.QueryString["ordered"]))
{
return;
}
DataTable dt;
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
int cartID = 0;
cartID = Convert.ToInt32(Request.QueryString["ordered"]);
parms.Add(new SqlJacknife.ParmStruct("@ID_Cart", cartID, 0, SqlDbType.Int, ParameterDirection.Input));
dt = SqlJacknife.GetDS("spLoadOrderedItems", parms).Tables[0];
if (dt.Rows.Count != 0)
{
grdCartItems.DataSource = dt;
grdCartItems.DataBind();
double subtotal = 0;
foreach (GridViewRow row in grdCartItems.Rows)
{
subtotal += Convert.ToDouble(row.Cells[4].Text.Substring(1));
}
lblSubtotal.Text = subtotal.ToString("c");
double tax = subtotal * 0.15;
double shipping = 0;
if (subtotal <= 75 && subtotal >= 35)
{
shipping = 12;
}
else if (subtotal < 35)
{
shipping = 7;
}
lblSubtotal.Text = subtotal.ToString("c");
lblTax.Text = tax.ToString("c");
lblShipping.Text = shipping.ToString("c");
lblTotal.Text = (subtotal + tax + shipping).ToString("c");
//double subtotal = Convert.ToDouble(grdCartItems.Rows[0].Cells[4].Text.Replace("$",""));
DataTable deets = SqlJacknife.GetDataTable("Get_OrderHistory_Details", parms);
lblAddress.Text = deets.Rows[0]["ShippingAddress"].ToString();
lblPayment.Text = deets.Rows[0]["PaymentType"].ToString();
}
else
{
master.messageNormal("You don't have any Item on order");
}
}
/// <summary>
/// Returns the unverified images that the current admin can verify
/// </summary>
/// <param name="ID_Adm"></param>
/// <returns>A datatable images</returns>
public DataTable Load_Unverified(int ID_Adm)
{
DataTable unverifiedImages = new DataTable();
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Adm", ID_Adm, 0, SqlDbType.Int, ParameterDirection.Input));
unverifiedImages = SqlJacknife.GetDataTable("Load_Unverified", parms);
return(unverifiedImages);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@SearchString", txtSearch.Text, 50, SqlDbType.VarChar, ParameterDirection.Input));
// SqlCommand cmd = new SqlCommand("Customers_by_Keywords", new SqlConnection(cnnString));
//cmd.CommandType = CommandType.StoredProcedure;
// SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = SqlJacknife.GetDataTable("Customers_by_Keywords", parms);
//da.Fill(dt);
try
{
if (dt.Rows.Count != 0)
{
customers.DataSource = dt;
customers.DataTextField = "username";
customers.DataValueField = "ID_Cust";
customers.DataBind();
customers.SelectedValue = Request.QueryString["IDCust"];
}
else
{
master.messageError("Customers not found!");
}
}
catch (Exception ex)
{
master.messageError(ex.Message);
}
}
/// <summary>
/// Loads all verified images
/// </summary>
/// <returns></returns>
public DataTable Load_Verified()
{
return(SqlJacknife.GetDataTable("Load_Verified", new List <SqlJacknife.ParmStruct>()));
}