public ActionResult Create([Bind(Include = "TerritoryID,TerritoryName")] TERRITORY tERRITORY)
{
if (ModelState.IsValid)
{
if (tERRITORY.TerritoryName == null)
{
ViewBag.Error = "Null Input!";
Session["ErrorMessage"] = ViewBag.Error;
return(View(tERRITORY));
}
var count = db.TERRITORies.ToList().Count();
if (count == 0)
{
tERRITORY.TerritoryID = "1";
tERRITORY.TerritoryName = "Canada";
db.TERRITORies.Add(tERRITORY);
}
else
{
tERRITORY.TerritoryID = "0" + (count + 1).ToString();
db.TERRITORies.Add(tERRITORY);
}
db.TERRITORies.Add(tERRITORY);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.Error = "Invalid Input!";
}
return(View(tERRITORY));
}
public ActionResult Create([Bind(Include = "EmployeeID,EmployeeName,EmployeeAddress,Supervisor")] EMPLOYEE eMPLOYEE)
{
if (ModelState.IsValid)
{
var count = db.EMPLOYEEs.ToList().Count();
if (count == 0)
{
eMPLOYEE.EmployeeID = "1";
eMPLOYEE.Supervisor = "CEO";
db.EMPLOYEEs.Add(eMPLOYEE);
}
else
{
eMPLOYEE.EmployeeID = (count + 1).ToString();
string supervisor = (db.EMPLOYEEs.Find(eMPLOYEE.Supervisor).EmployeeName) ?? " ";
eMPLOYEE.Supervisor = supervisor;
db.EMPLOYEEs.Add(eMPLOYEE);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeID = new SelectList(db.EMPLOYEEs, "EmployeeID", "EmployeeName", eMPLOYEE.EmployeeID);
return(View(eMPLOYEE));
}
public IHttpActionResult Putincident(string id, incident incident)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != incident.incident_type)
{
return(BadRequest());
}
db.Entry(incident).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!incidentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "Id,CheckinDate,CheckoutDate,RoomType,HotelId,UserId,Description")] Reservation reservation)
{
try
{
if (ModelState.IsValid)
{
db.Reservations.Add(reservation);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.HotelId = new SelectList(db.Hotels, "Id", "Name", reservation.HotelId);
}
catch (DbEntityValidationException ex)
{
foreach (var errors in ex.EntityValidationErrors)
{
foreach (var validationError in errors.ValidationErrors)
{
string errorMessage = validationError.ErrorMessage;
}
}
}
return View(reservation);
}
public ActionResult Create([Bind(Include = "SalespersonID,SalespersonName,SalespersonTelephone,SalespersonFax,TerritoryID")] SALESPERSON sALESPERSON)
{
if (ModelState.IsValid)
{
var count = db.SALESPERSONs.ToList().Count();
if (count == 0)
{
sALESPERSON.SalespersonID = "01";
sALESPERSON.SalespersonName = "Ikechukwu";
sALESPERSON.SalespersonTelephone = "2265068940";
sALESPERSON.SalespersonFax = "555673";
sALESPERSON.TerritoryID = "03";
}
else
{
sALESPERSON.SalespersonID = "0" + (count + 1).ToString();
}
db.SALESPERSONs.Add(sALESPERSON);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TerritoryID = new SelectList(db.TERRITORies, "TerritoryID", "TerritoryName", sALESPERSON.TerritoryID);
return(View(sALESPERSON));
}
public ActionResult Create([Bind(Include = "MaterialID,MaterialName,MaterialStandardCost,UnitOfMeasure")] RAWMATERIAL rawMaterial)
{
if (ModelState.IsValid)
{
var count = db.RAWMATERIALs.ToList().Count();
if (count == 0)
{
rawMaterial.MaterialID = "01";
rawMaterial.MaterialName = "Doe Material";
rawMaterial.MaterialStandardCost = "200";
rawMaterial.UnitOfMeasure = "1";
}
else
{
rawMaterial.MaterialID = "0" + (count + 1).ToString();
rawMaterial.UnitOfMeasure = rawMaterial.UnitOfMeasure ?? "1";
}
db.RAWMATERIALs.Add(rawMaterial);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rawMaterial));
}
public ActionResult Cart(int id, string username)
{
User User = db.User.Where(a => a.UserName == username).FirstOrDefault();
Product Product = db.Product.Find(id);
Product.UserId = User.UserId;
db.SaveChanges();
Session["totalprice"] = db.Product.Where(a => a.UserId == User.UserId).Sum(a => a.ProductPrice);
return(View(db.Product.Where(a => a.UserId == User.UserId).ToList()));
}
public ActionResult Create([Bind(Include = "Id,Name")] AspNetRoles aspNetRoles)
{
if (ModelState.IsValid)
{
db.AspNetRoles.Add(aspNetRoles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetRoles));
}
public ActionResult Create([Bind(Include = "ProductLineID,ProductLineName")] PRODUCT_LINE pRODUCT_LINE)
{
if (ModelState.IsValid)
{
db.PRODUCT_LINE.Add(pRODUCT_LINE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pRODUCT_LINE));
}
public ActionResult Create([Bind(Include = "Id,opis,data_start,data_koniec,color")] Spotkanie spotkanie)
{
if (ModelState.IsValid)
{
db.Spotkanie.Add(spotkanie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(spotkanie));
}
public ActionResult Create([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName")] AspNetUsers aspNetUsers)
{
if (ModelState.IsValid)
{
db.AspNetUsers.Add(aspNetUsers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetUsers));
}
public ActionResult Create([Bind(Include = "Cat_id,Cat_name")] categories_table categories_table)
{
if (ModelState.IsValid)
{
db.categories_tables.Add(categories_table);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categories_table));
}
public ActionResult Create([Bind(Include = "Id,Name,Address,StarLevel,UpdateDate")] Hotel hotel)
{
if (ModelState.IsValid)
{
db.Hotels.Add(hotel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hotel));
}
public ActionResult Create([Bind(Include = "Skill1")] SKILL sKILL)
{
if (ModelState.IsValid)
{
db.SKILLs.Add(sKILL);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sKILL));
}
public ActionResult Create([Bind(Include = "Id,UserId,ClaimType,ClaimValue")] AspNetUserClaims aspNetUserClaims)
{
if (ModelState.IsValid)
{
db.AspNetUserClaims.Add(aspNetUserClaims);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", aspNetUserClaims.UserId);
return(View(aspNetUserClaims));
}
public ActionResult Create([Bind(Include = "LoginProvider,ProviderKey,UserId")] AspNetUserLogins aspNetUserLogins)
{
if (ModelState.IsValid)
{
db.AspNetUserLogins.Add(aspNetUserLogins);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", aspNetUserLogins.UserId);
return(View(aspNetUserLogins));
}
public ActionResult Create([Bind(Include = "ProductID,ProductDescription,ProductFinish,ProductStandardPrice,ProductLineID")] PRODUCT pRODUCT)
{
if (ModelState.IsValid)
{
db.PRODUCTs.Add(pRODUCT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductLineID = new SelectList(db.PRODUCT_LINE, "ProductLineID", "ProductLineName", pRODUCT.ProductLineID);
return(View(pRODUCT));
}
public ActionResult Create([Bind(Include = "Pro_id,Pro_details,Pro_price,Pro_qty,Pro_name,Cat_Id")] product_table product_table)
{
if (ModelState.IsValid)
{
db.product_tables.Add(product_table);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Cat_Id = new SelectList(db.categories_tables, "Cat_id", "Cat_name", product_table.Cat_Id);
return(View(product_table));
}
public ActionResult Create([Bind(Include = "u_id,user_name,user_address,user_password,user_type")] user_table user_table)
{
if (ModelState.IsValid)
{
user_table.user_password = this.Hash(user_table.user_password);
db.user_tables.Add(user_table);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user_table));
}
public ActionResult Create([Bind(Include = "Id,Name,Model,image_path,vehicle_description")] Vehicle vehicle)
{
if (ModelState.IsValid)
{
vehicle.userId = User.Identity.GetUserId();
db.Vehicles.Add(vehicle);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.userId = new SelectList(db.AspNetUsers, "Id", "Email", vehicle.userId);
return(View(vehicle));
}
public ActionResult Create([Bind(Include = "VendorID,MaterialID,SupplyUnitPrice,SupplyID")] SUPPLy sUPPLy)
{
if (ModelState.IsValid)
{
sUPPLy.SupplyID = GenerateID(sUPPLy.VendorID, sUPPLy.MaterialID);
db.SUPPLIES.Add(sUPPLy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaterialID = new SelectList(db.RAWMATERIALs, "MaterialID", "MaterialName", sUPPLy.MaterialID);
ViewBag.VendorID = new SelectList(db.VENDORs, "VendorID", "VendorName", sUPPLy.VendorID);
return(View(sUPPLy));
}
public ActionResult Create([Bind(Include = "Id,id_funkcyjna,id_klient,id_spotkanie,status")] Lista_spotkan lista_spotkan)
{
if (ModelState.IsValid)
{
db.Lista_spotkan.Add(lista_spotkan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_spotkanie = new SelectList(db.Spotkanie, "Id", "opis", lista_spotkan.id_spotkanie);
ViewBag.id_funkcyjna = new SelectList(db.Uzytkownik, "Id", "imie", lista_spotkan.id_funkcyjna);
ViewBag.id_klient = new SelectList(db.Uzytkownik, "Id", "imie", lista_spotkan.id_klient);
return(View(lista_spotkan));
}
public ActionResult Create([Bind(Include = "OrderID,ProductID,OrderedQuantity")] OrderedLine orderedLine)
{
if (ModelState.IsValid)
{
orderedLine.OrderdedLineID = GenerateID(orderedLine.OrderID, orderedLine.ProductID, orderedLine.OrderedQuantity.ToString());
db.OrderedLines.Add(orderedLine);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrderID = new SelectList(db.ORDERs, "OrderID", "CustomerID", orderedLine.OrderID);
ViewBag.ProductID = new SelectList(db.PRODUCTs, "ProductID", "ProductDescription", orderedLine.ProductID);
return(View(orderedLine));
}
public ActionResult Create([Bind(Include = "ProductID,MaterialID,GoesIntoQuantity,UsesID")] US uS)
{
if (ModelState.IsValid)
{
uS.UsesID = GenerateID(uS.ProductID, uS.MaterialID);
db.USES.Add(uS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductID = new SelectList(db.PRODUCTs, "ProductID", "ProductDescription", uS.ProductID);
ViewBag.MaterialID = new SelectList(db.RAWMATERIALs, "MaterialID", "MaterialName", uS.MaterialID);
return(View(uS));
}
private void tbtYes_Click(object sender, EventArgs e)
{
try
{
string password = txtPassword.Text;
string newpasss = txtNewPassword.Text;
string newpassword = txtNewPass.Text;
//MessageBox.Show(password.ToString() + " " + nhanVien.MatKhau);
if (nhanVien.MatKhau.Trim() != password.ToString())
{
MessageBox.Show("Mật khẩu hiện tại không đúng");
return;
}
else if (newpasss.Trim() != newpassword.Trim())
{
MessageBox.Show("Mật khẩu mới nhập không khớp");
return;
}
else
{
nhanVien.MatKhau = newpasss;
// db.Set<NhanVien>().Attach(nhanVien);
db.Database.ExecuteSqlCommand("Update NhanVien set MatKhau ='" + newpasss + "' where MaNV = '" + nhanVien.MaNv + "'");
db.SaveChanges();
MessageBox.Show("Đổi Mật Khẩu Thành Công !");
this.Close();
frmMain frm = new frmMain(nhanVien);
frm.Show();
}
}
catch (Exception ex)
{
MessageBox.Show("Đổi Mật Khẩu Không Thành Công !" + ex.Message);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
string userName = txtID.Text;
string Add = txtDiaChi.Text;
string Phone = txtSDT.Text;
string name = txtHoTen.Text;
if (userName == "")
{
MessageBox.Show("Nhấp chọn vào nhân viên cần edit", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (Add == "" || Phone == "" || name == "")
{
MessageBox.Show("Thông tin không được để trông", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var user = db.NhanViens.Where(s => s.MaNv == userName).FirstOrDefault();
if (user != null)
{
//DataGridViewRow row = this.dgvListNV.Rows[local];
var query = ("Update NhanVien set TenNV = N'" + txtHoTen.Text + "' ,DiaChi = N'" + txtDiaChi.Text + "',SDT='" + txtSDT.Text + "' where MaNV=N'" + txtID.Text + "'");
db.Database.ExecuteSqlCommand(query);
db.SaveChanges();
Entities3 a = new Entities3();
var lst = a.NhanViens.ToList();
dgvListNV.DataSource = lst;
}
else
{
MessageBox.Show("Không tìm thấy ID trong database", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btCapNhat_Click(object sender, EventArgs e)
{
if (txtMaLoai.Text == "" || txtTenMon.Text == "" || txtGia.Text == "" || txtMaMon.Text == "")
{
MessageBox.Show("Vui long nhap day du thong tin mon an", "Thong bao", MessageBoxButtons.OK);
}
else
{
{
string Lmon = ("N'" + txtMaLoai.Text + "',N'" + txtTenMon.Text + "'");
string values = ("N'" + txtMaMon.Text + "',N'" + txtTenMon.Text + "',N'" + txtGia.Text + "',N'" + txtMaLoai.Text + "'");
context.Database.ExecuteSqlCommand("Insert into LoaiMon (MaLoai,TenMon) values (" + Lmon + ")");
context.SaveChanges();
context.Database.ExecuteSqlCommand("Insert into MonAn (MaMon,TenMon,GiaTien,MaLoai) values (" + values + ")");
context.SaveChanges();
MessageBox.Show("Thành công!", "Thông báo", MessageBoxButtons.OK);
this.Close();
}
}
}
public ActionResult Create([Bind(Include = "WorkCenterID,WorkCenterLocation")] WORKCENTER wORKCENTER)
{
if (ModelState.IsValid)
{
var count = db.WORKCENTERs.ToList().Count();
if (count == 0)
{
wORKCENTER.WorkCenterID = "01";
wORKCENTER.WorkCenterLocation = "101 Dalmation St";
}
else
{
wORKCENTER.WorkCenterID = "0" + (count + 1).ToString();
}
db.WORKCENTERs.Add(wORKCENTER);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(wORKCENTER));
}
public ActionResult Create([Bind(Include = "CustomerID,CustomerName,CustomerAddress,CustomerPostalCode")] CUSTOMER cUSTOMER)
{
if (ModelState.IsValid)
{
var count = db.TERRITORies.ToList().Count();
if (count == 0)
{
cUSTOMER.CustomerID = "1";
cUSTOMER.CustomerName = "John Doe";
cUSTOMER.CustomerPostalCode = "N96 2X6";
}
else
{
cUSTOMER.CustomerID = (count + 1).ToString();
}
db.CUSTOMERs.Add(cUSTOMER);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cUSTOMER));
}
public ActionResult Create([Bind(Include = "Id,facebook,instagram,snapchat,twitter,id_uzytkownik")] Spolecznosc spolecznosc)
{
if (ModelState.IsValid)
{
var u = db.AspNetUsers.SingleOrDefault(x => x.Email == User.Identity.Name);
Uzytkownik p = db.Uzytkownik.SingleOrDefault(x => x.id_aspUser == u.Id);
Spolecznosc a = db.Spolecznosc.SingleOrDefault(x => x.id_uzytkownik == p.Id);
if (a != null)
{
return(Redirect("/UzytkownikHome/Index"));
}
else
{
spolecznosc.id_uzytkownik = p.Id;
db.Spolecznosc.Add(spolecznosc);
db.SaveChanges();
return(Redirect("/UzytkownikHome/Index"));
}
}
// ViewBag.id_uzytkownik = new SelectList(db.Uzytkownik, "Id", "imie", spolecznosc.id_uzytkownik);
return(View(spolecznosc));
}
