protected void Page_Load(object sender, EventArgs e)
{
using (var db = new UITestEntities())
{
if (!IsPostBack)
{
var sup = from c in db.Supliers
orderby c.FirstName
select new { c.ID, c.FirstName };
DropDownList1.DataValueField = "ID";
DropDownList1.DataTextField = "FirstName";
DropDownList1.DataSource = sup.ToList();
var good = from c in db.PurchaseGoods
orderby c.Item
select new { c.ID, c.Item };
DropDownList2.DataValueField = "ID";
DropDownList2.DataTextField = "Item";
DropDownList2.DataSource = good.ToList();
DataBind();
DropDownList2.Items.Insert(0, "Select a Item");
DropDownList1.Items.Insert(0, "Select a Suplier");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("Error_404.aspx");
}
int id = Int32.Parse(Request.QueryString["id"]);
using (var db = new UITestEntities())
{
Buyer buyer = db.Buyers.Find(id);
if (buyer == null)
{
}
else
{
fname.Text = buyer.FirstName;
lname.Text = buyer.LastName;
address.Text = buyer.Address;
country.Text = buyer.Country;
telephone.Text = buyer.Telephone;
fax.Text = buyer.Fax;
email.Text = buyer.Email;
remarks.Text = buyer.Remarks;
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("Error_404.aspx");
}
int id = Int32.Parse(Request.QueryString["id"]);
using (var db = new UITestEntities())
{
Buyer buyer = db.Buyers.Single(u => u.ID == id);
buyer.FirstName = fname.Text;
buyer.LastName = lname.Text;
buyer.Address = address.Text;
buyer.Country = country.Text;
buyer.Telephone = telephone.Text;
buyer.Fax = fax.Text;
buyer.Email = email.Text;
buyer.Remarks = remarks.Text;
db.SaveChanges();
}
Response.Redirect("Search_Buyer.aspx");
}
public static void Save_User(User usr)
{
using (var db = new UITestEntities())
{
db.Users.Add(usr);
}
}
protected void Submit(object sender, EventArgs e)
{
try
{
UITestEntities db = new UITestEntities();
Suplier sup = new Suplier
{
FirstName = fname.Text.ToString(),
LastName = lname.Text.ToString(),
Address = address.Text.ToString(),
Telephone = telephone.Text.ToString(),
Fax = fax.Text.ToString(),
Email = email.Text.ToString(),
Remarks = remarks.Text.ToString()
};
db.Supliers.Add(sup);
db.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
public static string LoadTable()
{
JavaScriptSerializer TheSerializer = new JavaScriptSerializer();
using (var db = new UITestEntities())
{
var data = db.Supliers.OrderBy(o => o.ID).ToList();
var TheJson = TheSerializer.Serialize(data);
return(TheJson);
}
}
public static string LoadTypeDropDown(int id)
{
//edit this --------------------------------------------------------------------------------------------------------------------------
using (var db = new UITestEntities())
{
var good = from c in db.PurchaseGoods
orderby c.Item
select new { c.ID, c.Item };
return(JsonConvert.SerializeObject(good.ToList()));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var db = new UITestEntities())
{
User usr = new User
{
Username = Username.Text,
Password = Password.Text,
Type = Type.Text
};
}
}
public static string Search(string F)
{
string Fname = F;
using (UITestEntities db = new UITestEntities())
{
if (Fname != "")
{
var buyer = from c in db.Supliers
where c.FirstName.Contains(Fname)
select c;
return(JsonConvert.SerializeObject(buyer));
}
else
{
var buyer = db.Supliers.ToList();
return(JsonConvert.SerializeObject(buyer));
}
}
}
protected void BuyerSaveBtn_Click(object sender, EventArgs e)
{
var buyer = new Buyer();
using (UITestEntities DB = new UITestEntities())
{
try
{
buyer.ID = 1;
buyer.FirstName = fname.Text;
buyer.LastName = lname.Text;
buyer.Address = address.Text;
buyer.Country = country.Text;
buyer.Telephone = telephone.Text;
buyer.Fax = fax.Text;
buyer.Email = email.Text;
buyer.Remarks = remarks.Text;
DB.Buyers.Add(buyer);
DB.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
private void GreetingBtn_Click(Object sender, EventArgs e)
{
try
{
using (UITestEntities ctx = new UITestEntities())
{
ctx.Database.Connection.Open();
var usr = ctx.Users.Where(o => o.Username == txtusername.Text.ToString()).ToList <User>();
if (usr.Count == 0)
{
Label1.Text = "errrroooo";
}
else
{
if (usr[0].Password == txtpassword.Text)
{
if (usr[0].Type.Equals("Admin "))
{
Session["UserName"] = usr[0].Username;
Label1.Text = "Pleace Wait";
Response.Redirect("Home.aspx", false);
}
else
{
Response.Redirect("");
}
}
else
{
Label1.Text = "asfq";
}
}
}
}
catch (Exception ex)
{
Response.Redirect("Error_404.aspx");
throw;
}
// Display the greeting label text.
}
public static string Search(string F, string L, string C)
{
string Fname = F;
string Lname = L;
string Country = C;
using (UITestEntities db = new UITestEntities())
{
//var buyerL = db.Buyers.Where(o => o.LastName == Lname);
//var buyerC = db.Buyers.Where(o => o.Country == Country);
if (Fname != "" && Lname != "" && Country != "")
{
var buyer = db.Buyers.Where(o => o.FirstName == Fname && o.LastName == Lname && o.Country == Country).ToList();
//var buyer = from c in db.Buyers
// where c.FirstName.Contains(Fname)
// select c;
return(JsonConvert.SerializeObject(buyer));
}
else if (Fname != "" && Lname != "")
{
var buyer = db.Buyers.Where(o => o.FirstName == Fname && o.LastName == Lname).ToList();
return(JsonConvert.SerializeObject(buyer));
}
else if (Fname != "" && Country != "")
{
var buyer = db.Buyers.Where(o => o.FirstName == Fname && o.Country == Country).ToList();
return(JsonConvert.SerializeObject(buyer));
}
else if (Lname != "" && Country != "")
{
var buyer = db.Buyers.Where(o => o.LastName == Lname && o.Country == Country).ToList();
return(JsonConvert.SerializeObject(buyer));
}
else if (Fname != "")
{
//var buyer = db.Buyers.Where(o =>o.FirstName == Fname).ToList();
var buyer = from c in db.Buyers
where c.FirstName.Contains(Fname)
select c;
return(JsonConvert.SerializeObject(buyer));
}
else if (Lname != "")
{
//var buyer = db.Buyers.Where(o => o.LastName == Lname).ToList();
var buyer = from c in db.Buyers
where c.LastName.Contains(Lname)
select c;
return(JsonConvert.SerializeObject(buyer));
}
else if (Country != "")
{
//var buyer = db.Buyers.Where(o => o.Country == Country).ToList();
var buyer = from c in db.Buyers
where c.Country.Contains(Country)
select c;
return(JsonConvert.SerializeObject(buyer));
}
else
{
var buyer = db.Buyers.ToList();
return(JsonConvert.SerializeObject(buyer));
}
}
}