public ActionResult Create([Bind(Include = "FriendId,FriendName,Place")] FriendTable friendTable)
{
if (ModelState.IsValid)
{
db.FriendTables.Add(friendTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(friendTable));
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try {
string name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_name")).Text;
string phone = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_phone")).Text;
string fax = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_fax")).Text;
string mobile = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_mobile")).Text;
string email = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_email")).Text;
string website = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_website")).Text;
int id = (int)GridView1.DataKeys[e.RowIndex].Value;
FriendsEntities ent = new FriendsEntities();
var wh = (from warehouse in ent.Customers
where warehouse.Customer_Id == id
select warehouse).First();
wh.Customer_Name = name;
wh.Customer_Email = email;
wh.Customer_Website = website;
wh.Customer_Phone = int.Parse(phone);
wh.Customer_Mobile_Phone = int.Parse(mobile);
wh.Customer_Fax = int.Parse(fax);
ent.SaveChanges();
ent.SaveChanges();
GridView1.EditIndex = -1;
var ds = (from wh2 in ent.Customers
select new
{
wh2.Customer_Id,
wh2.Customer_Name,
wh2.Customer_Phone,
wh2.Customer_Fax,
wh2.Customer_Mobile_Phone,
wh2.Customer_Email,
wh2.Customer_Website
}).ToList();
GridView1.DataSource = ds;
GridView1.DataBind();
mpePopUp.Show();
Label2.Text = " the Customer is Updated";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void Button5_Click(object sender, EventArgs e)
{
try {
Ex_Per_Item epi = new Ex_Per_Item();
epi.Ex_Per_Id = int.Parse(TextBox2.Text);
epi.Ex_Per_Item_Id = int.Parse(DropDownList2.SelectedValue);
epi.Cus_ID = int.Parse(DropDownList3.SelectedValue);
epi.Ex_Per_Item_Quantity = int.Parse(TextBox4.Text);
FriendsEntities ent = new FriendsEntities();
ent.Ex_Per_Item.AddObject(epi);
ent.SaveChanges();
TextBox4.Text = string.Empty;
mpePopUp.Show();
Label2.Text = "item is added to permission number : " + epi.Ex_Per_Id;
DropDownList1.SelectedValue = default;
DropDownList2.SelectedValue = default;
DropDownList3.SelectedValue = default;
//ep.Ex_Per_WH_Id = int.Parse(DropDownList1.SelectedValue);
//ep.Ex_Per_Date = DateTime.Parse(Request["txtDatePicker3"].ToString());
//FriendsEntities ent = new FriendsEntities();
//ent.Export_Permission.AddObject(ep);
//ent.SaveChanges();
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void Button5_Click(object sender, EventArgs e)
{
try {
Sup_Per_Item spi = new Sup_Per_Item();
spi.Sup_Per_Id = int.Parse(TextBox2.Text);
spi.Sup_Per_Item_Id = int.Parse(DropDownList2.SelectedValue);
spi.Sup_Per_Item_Quantity = int.Parse(TextBox3.Text);
spi.Sup_Per_Item_Pro_Date = DateTime.Parse(Request["txtDatePicker2"].ToString());
spi.Sup_Per_Item_Validation = int.Parse(TextBox4.Text);
spi.Sup_Id = int.Parse(DropDownList3.SelectedValue);
FriendsEntities ent = new FriendsEntities();
ent.Sup_Per_Item.AddObject(spi);
ent.SaveChanges();
TextBox4.Text = string.Empty;
mpePopUp.Show();
Label2.Text = "item is added to permission number : " + spi.Sup_Per_Id;
DropDownList1.SelectedValue = default;
DropDownList2.SelectedValue = default;
DropDownList3.SelectedValue = default;
TextBox4.Text = string.Empty;
TextBox3.Text = string.Empty;
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try {
int id = (int)GridView1.DataKeys[e.RowIndex].Value;
FriendsEntities ent = new FriendsEntities();
var wh = (from warehouse in ent.Customers
where warehouse.Customer_Id == id
select warehouse).First();
ent.Customers.DeleteObject(wh);
ent.SaveChanges();
var ds = (from wh2 in ent.Customers
select new
{
wh2.Customer_Id,
wh2.Customer_Name,
wh2.Customer_Phone,
wh2.Customer_Fax,
wh2.Customer_Mobile_Phone,
wh2.Customer_Email,
wh2.Customer_Website
}).ToList();
GridView1.DataSource = ds;
GridView1.DataBind();
mpePopUp.Show();
Label2.Text = "The Customer is Deleted";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
Customer wh = new Customer();
wh.Customer_Id = int.Parse(TextBox1.Text);
wh.Customer_Name = TextBox2.Text;
wh.Customer_Phone = int.Parse(TextBox3.Text);
wh.Customer_Fax = int.Parse(TextBox4.Text);
wh.Customer_Mobile_Phone = int.Parse(TextBox5.Text);
wh.Customer_Email = TextBox6.Text;
wh.Customer_Website = TextBox7.Text;
FriendsEntities ent = new FriendsEntities();
ent.Customers.AddObject(wh);
ent.SaveChanges();
TextBox1.Text = string.Empty;
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;
TextBox4.Text = string.Empty;
TextBox5.Text = string.Empty;
TextBox6.Text = string.Empty;
TextBox7.Text = string.Empty;
mpePopUp.Show();
Label2.Text = "New Customer is added";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int id = (int)GridView1.DataKeys[e.RowIndex].Value;
FriendsEntities ent = new FriendsEntities();
var wh = (from warehouse in ent.Warehouses
where warehouse.WH_Id == id
select warehouse).First();
ent.Warehouses.DeleteObject(wh);
ent.SaveChanges();
var ds = (from wh2 in ent.Warehouses
select new
{
wh2.WH_Id,
wh2.WH_Name,
wh2.WH_Location,
wh2.WH_Manager
}).ToList();
GridView1.DataSource = ds;
GridView1.DataBind();
mpePopUp.Show();
Label2.Text = "The Warehouse is Deleted";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
Warehouse wh = new Warehouse();
wh.WH_Id = int.Parse(TextBox1.Text);
wh.WH_Name = TextBox2.Text;
wh.WH_Location = TextBox3.Text;
wh.WH_Manager = TextBox4.Text;
FriendsEntities ent = new FriendsEntities();
ent.Warehouses.AddObject(wh);
ent.SaveChanges();
TextBox1.Text = string.Empty;
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;
TextBox4.Text = string.Empty;
mpePopUp.Show();
Label2.Text = "New Warehouse is added";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try {
Item itm = new Item();
itm.Item_Id = int.Parse(TextBox1.Text);
itm.Item_Code = int.Parse(TextBox2.Text);
itm.Item_Name = TextBox3.Text;
FriendsEntities ent = new FriendsEntities();
ent.Items.AddObject(itm);
ent.SaveChanges();
TextBox1.Text = string.Empty;
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;
mpePopUp.Show();
Label2.Text = "New Item is added";
var itms = (from itm2 in ent.Items
select new { itm2.Item_Id, itm2.Item_Name });
DropDownList1.DataSource = itms;
DropDownList1.DataTextField = "Item_Name";
DropDownList1.DataValueField = "Item_Id";
DropDownList1.DataBind();
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int id = (int)GridView1.DataKeys[e.RowIndex].Value;
FriendsEntities ent = new FriendsEntities();
var item = (from itm in ent.Items
where itm.Item_Id == id
select itm).First();
ent.Items.DeleteObject(item);
ent.SaveChanges();
var ds = (from itms in ent.Items
select new
{
itms.Item_Id,
itms.Item_Code,
itms.Item_Name
}).ToList();
GridView1.DataSource = ds;
GridView1.DataBind();
mpePopUp.Show();
Label2.Text = "The item is Deleted";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try {
string name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_name")).Text;
int code = int.Parse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_code")).Text);
int id = (int)GridView1.DataKeys[e.RowIndex].Value;
FriendsEntities ent = new FriendsEntities();
var wh = (from itm in ent.Items
where itm.Item_Id == id
select itm).First();
wh.Item_Name = name;
wh.Item_Code = code;
ent.SaveChanges();
GridView1.EditIndex = -1;
var ds = (from itms in ent.Items
select new
{
itms.Item_Id,
itms.Item_Code,
itms.Item_Name
}).ToList();
GridView1.DataSource = ds;
GridView1.DataBind();
mpePopUp.Show();
Label2.Text = " the item is Updated";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
Transfer t = new Transfer();
t.Trans_Id = int.Parse(TextBox3.Text);
t.WH_From_Id = int.Parse(DropDownList1.SelectedValue);
t.WH_To_Id = int.Parse(DropDownList2.SelectedValue);
t.Item_Id = int.Parse(DropDownList3.SelectedValue);
t.Quantity = int.Parse(TextBox1.Text);
t.Sup_Id = int.Parse(DropDownList4.SelectedValue);
t.Pro_Date = DateTime.Parse(Request["txtDatePicker3"].ToString());
t.Validation = int.Parse(TextBox2.Text);
FriendsEntities ent = new FriendsEntities();
ent.Transfers.AddObject(t);
ent.SaveChanges();
TextBox1.Text = string.Empty;
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;
DropDownList1.SelectedValue = default;
DropDownList2.SelectedValue = default;
DropDownList3.SelectedValue = default;
DropDownList4.SelectedValue = default;
mpePopUp.Show();
Label2.Text = "New Transfer Done";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void Button5_Click(object sender, EventArgs e)
{
try {
Items_MU mu = new Items_MU();
mu.Item_Id = int.Parse(DropDownList1.SelectedValue);
mu.MU_Name = TextBox4.Text;
FriendsEntities ent = new FriendsEntities();
ent.Items_MU.AddObject(mu);
ent.SaveChanges();
TextBox4.Text = string.Empty;
DropDownList1.SelectedValue = default;
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try {
Export_Permission ep = new Export_Permission();
ep.Ex_Per_Id = int.Parse(TextBox1.Text);
ep.Ex_Per_WH_Id = int.Parse(DropDownList1.SelectedValue);
ep.Ex_Per_Date = DateTime.Parse(Request["txtDatePicker3"].ToString());
FriendsEntities ent = new FriendsEntities();
ent.Export_Permission.AddObject(ep);
ent.SaveChanges();
mpePopUp.Show();
Label2.Text = "Permission Done";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
string name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_name")).Text;
string location = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_loc")).Text;
string manager = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_manager")).Text;
int id = (int)GridView1.DataKeys[e.RowIndex].Value;
FriendsEntities ent = new FriendsEntities();
var wh = (from warehouse in ent.Warehouses
where warehouse.WH_Id == id
select warehouse).First();
wh.WH_Name = name;
wh.WH_Location = location;
wh.WH_Manager = manager;
ent.SaveChanges();
GridView1.EditIndex = -1;
var ds = (from wh2 in ent.Warehouses
select new
{
wh2.WH_Id,
wh2.WH_Name,
wh2.WH_Location,
wh2.WH_Manager
}).ToList();
GridView1.DataSource = ds;
GridView1.DataBind();
mpePopUp.Show();
Label2.Text = " the Warehouse is Updated";
}
catch
{
mpePopUp.Show();
Label2.Text = "try again";
}
}
