protected void Search_Click(object sender, EventArgs e)
{
try
{
var loggedin = UserLogin.getSession();
SqlCommand cmd = new SqlCommand("select * from Product where img='" + txtImgId.Text + "'", con);
SqlDataAdapter adpData = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
dt.Clear();
adpData.Fill(dt);
DataList2.DataSource = dt;
DataList2.DataBind();
flag = true;
con.Close();
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter the img id with extention(image1.jpg).');", true);
errorMsg.Visible = true;
errorMsg.Text = "No Item Found";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (UserLogin.getSession().Equals(""))
{
Response.Redirect("UserLogin.aspx");
}
else
{
try
{
errorMsg.Visible = false;
SqlCommand cmd = new SqlCommand("select * from Product where email='" + UserLogin.getSession() + "'", con);
SqlDataAdapter adpData = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adpData.Fill(dt);
DataList2.DataSource = dt;
DataList2.DataBind();
con.Close();
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('No data found regards given image id..');", true);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtPrice.Text.Equals("") || txtQuantity.Text.Equals("") || startDate.Text.Equals("") || endDate.Text.Equals("") || imgFile.Equals(""))
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please fill all the fields.');", true);
}
else
{
string path = Path.GetFileName(imgFile.PostedFile.FileName);
imgFile.SaveAs(@"C:\Users\user\source\repos\Sales_pk\Sales_pk\User_Interface_Layer\Product_Images\" + path);
int quan = Convert.ToInt32(txtQuantity.Text);
int pric = Convert.ToInt32(txtPrice.Text);
var strt = Convert.ToDateTime(startDate.Text);
var end = Convert.ToDateTime(endDate.Text);
var today = DateTime.Now;
if ((quan > 0) && (pric > 0) && (strt >= today) && (end > today) && (end > strt))
{
Product product = new Product();
using (Entities db = new Entities())
{
var loggedin = UserLogin.getSession();
User user = db.Users.Where(x => x.email == loggedin).FirstOrDefault();
var imagPath = "Product_Images/" + path;
var pic = db.Products.Where(x => x.img == imagPath).Any();
if (pic == false)
{
product.email = user.email;
product.size = sizeDdl.SelectedItem.Text;
product.price = pric;
product.quantity = quan;
product.start_date = strt;
product.end_date = end;
product.img = "Product_Images/" + path;
product.gender = genderDdl.SelectedItem.Text;
product.location = user.location;
product.city = user.city;
product.brand = user.brand;
db.Products.Add(product);
db.SaveChanges();
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Data Successfully added.');", true);
txtPrice.Text = "";
txtQuantity.Text = "";
startDate.Text = "";
endDate.Text = "";
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('This image already uploaded. Please rename or or make sure about it.');", true);
}
}
}
else
{
if (quan > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Invalid Quantity.');", true);
}
if ((pric > 0))
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Invalid Price.');", true);
}
if (strt >= today)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Invalid Start. Must after or today');", true);
}
if (end >= today)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Invalid end. Must after today or start date');", true);
}
}
}
}