public string InsertSingleCRUDData(SingleCRUD singleCRUDData)
{
try
{
SingleCRUD singleCRUD = (from singleData in _db.SingleCRUD
where singleData.Id == singleCRUDData.Id
select singleData).FirstOrDefault();
//搜尋出重複資料，新增失敗
if (singleCRUD != null)
{
return("新增到重複SingleCRUD資料，新增失敗");
}
singleCRUDData.Upuser = "******";
singleCRUDData.Updatetime = DateTime.Now;
singleCRUDData.Cruser = "******";
singleCRUDData.Crdatetime = DateTime.Now;
_db.SingleCRUD.Add(singleCRUDData);
_db.SaveChanges();
return("true");
}
catch (Exception ex)
{
return("false");
}
}
public string InsertColumnCRUDData(ColumnCRUD columnCRUDData)
{
try
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始新增一筆ColumnCRUD資料", columnCRUDData, null);
ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD
where column.Id == columnCRUDData.Id
select column).FirstOrDefault();
//搜尋出重複資料，新增失敗
if (columnCRUD != null)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增到重複PKey的ColumnCRUD資料，取消新增動作", columnCRUDData.Id, null);
return("新增到重複ColumnCRUD資料，新增失敗");
}
columnCRUDData.Upuser = "******";
columnCRUDData.Updatetime = DateTime.Now;
columnCRUDData.Cruser = "******";
columnCRUDData.Crdatetime = DateTime.Now;
_db.ColumnCRUD.Add(columnCRUDData);
_db.SaveChanges();
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "新增一筆ColumnCRUD資料結束", columnCRUDData.Id, null);
return("true");
}
catch (Exception ex)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增一筆ColumnCRUD資料，發生錯誤", columnCRUDData, ex);
return("false");
}
}
public int AddEmployee(Employee model)
{
using (var context = new TestDBEntities())
{
if (model.Address != null)
{
Address objadd = new Address()
{
Details = model.Address.Details,
Country = model.Address.Country,
State = model.Address.State
};
context.Addresses.Add(objadd);
context.SaveChanges();
model.AddressId = objadd.Id;
}
Employee emp = new Employee()
{
FirstName = model.FirstName,
LastName = model.LastName,
Email = model.Email,
Code = model.Code,
AddressId = model.AddressId
//AddressId=_add.Id
};
context.Employees.Add(emp);
context.SaveChanges();
return(emp.Id);
}
}
public ActionResult UserSelect()
{
var model = db.kullanici.Include(m => m.Sehirler).ToList();
db.SaveChanges();
return(View(model));
}
public string InsertColumnCRUDData(ColumnCRUD columnCRUDData)
{
try
{
ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD
where column.Id == columnCRUDData.Id
select column).FirstOrDefault();
//搜尋出重複資料，新增失敗
if (columnCRUD != null)
{
return("新增到重複ColumnCRUD資料，新增失敗");
}
columnCRUDData.Upuser = "******";
columnCRUDData.Updatetime = DateTime.Now;
columnCRUDData.Cruser = "******";
columnCRUDData.Crdatetime = DateTime.Now;
_db.ColumnCRUD.Add(columnCRUDData);
_db.SaveChanges();
return("true");
}
catch (Exception ex)
{
return("false");
}
}
public ActionResult Save(Contact objContact)
{
objCont.Name = objContact.Name;
objCont.Address = objContact.Address;
objCont.Contact_Number = objContact.Contact_Number;
db.Contacts.Add(objCont);
db.SaveChanges();
objCont.contactList = db.Contacts.ToList();
return(View("Index", objCont.contactList));
}
public ActionResult AddUser(UsersModel obj)
{
contextobj.Users.Add(new User()
{
Name = obj.UserName, Age = obj.Age
});
contextobj.SaveChanges();
return(View("AddUser", obj));
}
public ActionResult Create([Bind(Include = "ID,CampaignName,Date,Clicks,Conversions,Impressions,AffiliateName")] DevTest devTest)
{
if (ModelState.IsValid)
{
db.DevTests.Add(devTest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(devTest));
}
public ActionResult Create([Bind(Include = "ITEM_ID,ITEM_DESRIPTION,CATEGORY_ID,isActive")] ITEMS iTEMS)
{
if (ModelState.IsValid)
{
db.ITEMS.Add(iTEMS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(iTEMS));
}
public ActionResult Create([Bind(Include = "Department_Code,Part_Code,Module_Code,Module_Title,Active")] timetable_module timetable_module)
{
if (ModelState.IsValid)
{
db.timetable_module.Add(timetable_module);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(timetable_module));
}
public ActionResult Create(logininfo logininfo)
{
if (ModelState.IsValid)
{
db.logininfoes.Add(logininfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(logininfo));
}
public ActionResult Create([Bind(Include = "SUPPLIER_ID,SUPPLIERS_NAME,ADDRESS,PHONE_NUMBER,isActive")] SUPPLIERS sUPPLIERS)
{
if (ModelState.IsValid)
{
db.SUPPLIERS.Add(sUPPLIERS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sUPPLIERS));
}
public ActionResult Create(Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public ActionResult Create([Bind(Include = "Park_ID,Building_ID,Room_ID,Capacity,Type_ID")] timetable_room timetable_room)
{
if (ModelState.IsValid)
{
db.timetable_room.Add(timetable_room);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(timetable_room));
}
public ActionResult Create(labtask labtask)
{
if (ModelState.IsValid)
{
db.labtasks.Add(labtask);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(labtask));
}
public ActionResult Create([Bind(Include = "MemberID,Password,UserName,Email,Age,CellPhone,Blog,CreateDate")] Members members)
{
if (ModelState.IsValid)
{
db.Members.Add(members);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(members));
}
public ActionResult Create([Bind(Include = "EmpID,Name,City,MobileNo,birthdate,Email")] tblEmp tblEmp)
{
if (ModelState.IsValid)
{
db.tblEmps.Add(tblEmp);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblEmp));
}
public ActionResult Create([Bind(Include = "Facility_ID,Facility_Name")] timetable_facility timetable_facility)
{
if (ModelState.IsValid)
{
db.timetable_facility.Add(timetable_facility);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(timetable_facility));
}
public Product Add(Product item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
// TO DO : Code to save record into database
db.Products.Add(item);
db.SaveChanges();
return(item);
}
// POST: api/Emp
public void Post([FromBody] EmployeeCustomClass emp)
{
Console.WriteLine(emp);
tbDepartment dep = empDb.tbDepartments.FirstOrDefault(e => e.d_name.Equals(emp.DeptName));
tbEmployee newEmp = new tbEmployee();
newEmp.e_name = emp.EmpName;
newEmp.tbDepartment = dep;
//ef
empDb.tbEmployees.Add(newEmp);
empDb.SaveChanges();
}
public int Delete(int id)
{
var modelToDelete = _db.tblTests.Find(id);
var practiceModel = new tblTest();
if (modelToDelete != null)
{
practiceModel = _db.tblTests.Remove(modelToDelete);
}
_db.SaveChanges();
return(practiceModel.Id);
}
public ActionResult Create([Bind(Include = "MOVE_ORDER_ID,MOVE_ORDER_NUMBER,ITEM_ID,PRICE,QUANTITY,STORE_ID,STOCK_ID")] MOVE_ORDERS mOVE_ORDERS)
{
if (ModelState.IsValid)
{
db.MOVE_ORDERS.Add(mOVE_ORDERS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ITEM_ID = new SelectList(db.ITEMS, "ITEM_ID", "ITEM_DESRIPTION", mOVE_ORDERS.ITEM_ID);
ViewBag.STOCK_ID = new SelectList(db.STOCKS, "STOCK_ID", "ADDRESS", mOVE_ORDERS.STOCK_ID);
ViewBag.STORE_ID = new SelectList(db.STORE, "STORE_ID", "STORE_NAME", mOVE_ORDERS.STORE_ID);
return(View(mOVE_ORDERS));
}
public ActionResult Create([Bind(Include = "PURCHASE_ID,PURCHASE_NUMBER,ITEM_ID,PRICE,QUANTITY,PURCHASE_DATE,STOCK_ID,SUPPLIER_ID")] ITEMS_PURCHASE iTEMS_PURCHASE)
{
if (ModelState.IsValid)
{
db.ITEMS_PURCHASE.Add(iTEMS_PURCHASE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ITEM_ID = new SelectList(db.ITEMS, "ITEM_ID", "ITEM_DESRIPTION", iTEMS_PURCHASE.ITEM_ID);
ViewBag.STOCK_ID = new SelectList(db.STOCKS, "STOCK_ID", "ADDRESS", iTEMS_PURCHASE.STOCK_ID);
ViewBag.SUPPLIER_ID = new SelectList(db.SUPPLIERS, "SUPPLIER_ID", "SUPPLIERS_NAME", iTEMS_PURCHASE.SUPPLIER_ID);
return(View(iTEMS_PURCHASE));
}
public ActionResult Create(EMPLOYEE employee)
{
if (ModelState.IsValid)
{
db.EMPLOYEEs.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
MessageBox.Show("processed correctly");
}
return(View(employee));
MessageBox.Show("processed correctly");
}
public ActionResult AddStudent(Student student)
{
// Save
_db.People.Add(new People
{
Name = student.Name,
LastName = student.LastName,
BirthDate = student.BirthDate,
City = student.City,
Email = student.Email
});
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public void DelStudentFromClass()
{
Console.WriteLine("Исключение ученика из класса");
Console.WriteLine("Введите id ученика: ");
int idStudent = InsertNumber();
Console.WriteLine("Введите id класса: ");
int idClass = InsertNumber();
if (IsHaveStudents(idStudent) && IsHaveClass(idClass))
{
if (IsHaveStudentInClass(idStudent, idClass))
{
using (TestDBEntities context = new TestDBEntities())
{
Students selectStudent = context.Students
.Where(s => s.StudentsId == idStudent && s.IsDelete == false)
.FirstOrDefault();
selectStudent.ClassId = null;
context.SaveChanges();
}
Console.WriteLine("Ученик исключен из класса");
}
}
else
{
Console.WriteLine("Не существует указанного ученика или класса.");
}
}
public JsonResult SaveCustomerData(Customer customer)
{
bool status = false;
string message = "";
if (ModelState.IsValid)
{
using (TestDBEntities dc = new TestDBEntities())
{
var query = dc.Customers.Where(a => a.Id == customer.Id).FirstOrDefault();
if (query == null)
{
customer.CreateDate = DateTime.Now;
dc.Customers.Add(customer);
}
else
{
query.Name = customer.Name;
query.Email = customer.Email;
query.Country = customer.Country;
query.ZipCode = customer.ZipCode;
}
dc.SaveChanges();
status = true;
message = "Save Complete";
}
}
else
{
message = "Failed! Please try again";
}
return(new JsonResult {
Data = new { status = status, message = message }
});
}
public JsonResult DeleteCustomer(Customer customer)
{
bool status = false;
string message = "";
if (ModelState.IsValid)
{
using (TestDBEntities dc = new TestDBEntities())
{
var query = dc.Customers.Where(a => a.Id == customer.Id).FirstOrDefault();
if (query != null)
{
dc.Customers.Remove(query);
}
dc.SaveChanges();
status = true;
message = "Deleted Complete";
}
}
else
{
message = "Failed! Please try again";
}
return(new JsonResult {
Data = new { status = status, message = message }
});
}
// GET: TestSonuclari
public ActionResult TestSonuclari()
{
var model = db.kullanici.Include(m => m.Sehirler).Where(m => m.Sonuc != null).ToList();
db.SaveChanges();
return(View(model));
}
public HttpResponseMessage UpdateEmployee([FromUri] int id, [FromBody] employee employee)
{
try
{
using (TestDBEntities entities = new TestDBEntities())
{
var entity = entities.employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID: " + id + " does not exist"));
}
else
{
entity.Name = employee.Name;
entity.Department = employee.Department;
entity.Salary = employee.Salary;
entity.Gender = employee.Gender;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
