public static bool Login(string username, string password)
{
using (dataEntities entities = new dataEntities())
{
return(entities.Users.Any(user => user.UserName.Equals(username, StringComparison.OrdinalIgnoreCase) && user.Password.Equals(password, StringComparison.OrdinalIgnoreCase)));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (dataEntities entities = new dataEntities())
{
//삭제한걸 또 삭제할 경우 Rmove 에 null 전달 후 예외 발생
//entities.Employees.Remove(entities.Employees.FirstOrDefault(e => e.ID == id));
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Employee with Id = " + id.ToString() + " not Found to delete"));
}
else
{
entities.Employees.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Put(int id, [FromBody] Employees employee)
{
// 500 internal server error 가 발생할 수 있다.
using (dataEntities entities = new dataEntities())
{
try
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Employee with Id = " + id.ToString() + " not Found to update"));
}
else
{
entity.FirstName = employee.FirstName;
entity.LastName = employee.LastName;
entity.Gender = employee.Gender;
entity.Salary = employee.Salary;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
}
public ActionResult Index()
{
dataEntities db = new dataEntities();
var query = db.DBtestUsers.ToList();
return(View(query));
}
public string Putproduct([FromBody] product modifiedProduct)
{
using (dataEntities db = new dataEntities())
{
try
{
var Product = db.products.Where(c => c.id == modifiedProduct.id).FirstOrDefault();
//Product = modifiedProduct;
//db.Entry(Product).State = EntityState.Modified;
Product.name = modifiedProduct.name;
Product.NSX = modifiedProduct.NSX;
Product.image1 = modifiedProduct.image1;
Product.image1 = modifiedProduct.image2;
Product.image1 = modifiedProduct.image3;
Product.price = modifiedProduct.price;
Product.unit = modifiedProduct.unit;
db.SaveChanges();
return("Modify successfully");
}
catch (Exception)
{
return("Modify fail");
}
}
}
public ActionResult Delete(int id)
{
using (dataEntities db = new dataEntities())
{
DBtestUser emp = db.DBtestUsers.Where(x => x.Id == id).FirstOrDefault <DBtestUser>();
db.DBtestUsers.Remove(emp);
db.SaveChanges();
return(Json(new { success = true, message = "Data Successfully Deleted" }, JsonRequestBehavior.AllowGet));
}
}
public product Get(int id)
{
using (dataEntities da = new dataEntities())
{
return(da.products.FirstOrDefault(c => c.id == id && c.status == true));
}
using (dataEntities da = new dataEntities())
{
return(da.products.FirstOrDefault(c => c.id == id && c.status == true));
}
}
public IEnumerable <product> Get()
{
using (dataEntities da = new dataEntities())
{
return(da.products.Select(x => x).Where(x => x.status == true).ToList());
}
//using (dataEntities da = new dataEntities())
//{
// return da.products.Select(x => x).Where(x => x.status == true).ToList();
//}
}
public ActionResult AddSet(int id = 0)
{
if (id == 0)
{
return(View(new DBtestUser()));
}
else
{
using (dataEntities db = new dataEntities())
{
return(View(db.DBtestUsers.Where(x => x.Id == id).FirstOrDefault <DBtestUser>()));
}
}
}
public HttpResponseMessage LoadAllEmployeesById(int id)
{
using (dataEntities data = new dataEntities())
{
var entity = data.Employees.FirstOrDefault(e => e.ID == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Employee with Id = " + id.ToString() + " not Found"));
}
}
}
public string Put([FromBody] product deletedProduct)
{
using (dataEntities db = new dataEntities())
{
try
{
var deletedEmployee = db.products.Where(c => c.id == deletedProduct.id).FirstOrDefault();
deletedEmployee.status = false;
db.SaveChanges();
return("Delete successfully");
}
catch (Exception)
{
return("Delete fail");
}
}
}
public product Post([FromBody] product newProduct)
{
using (dataEntities da = new dataEntities())
{
try
{
newProduct.status = true;
da.products.Add(newProduct);
da.SaveChanges();
return(newProduct);
}
catch
{
}
return(null);
}
}
public HttpResponseMessage Post([FromBody] Employees employee)
{
try
{
using (dataEntities entities = new dataEntities())
{
entities.Employees.Add(employee);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, employee);
message.Headers.Location = new Uri(Request.RequestUri + employee.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public List <ProjectRoleDto> GetProjectRoles(int projectid) //Aldığı projectid ye göre proje,user,projectrole'e
{ //join işlemi yapıp. Projede hangi çalışanlar olduğunu gösteren kod.
using (UnitOfWorkPattern unitOf = new UnitOfWorkPattern())
{
dataEntities _context = new dataEntities();
List <ProjectRoleDto> rolesDtosLi = (from prol in _context.projectroles
join us in _context.users on prol.userid equals us.id
join proj in _context.projects on prol.projectid equals proj.id
where prol.projectid == projectid
select new ProjectRoleDto
{
UserName = us.username,
UserId = us.id,
ProjectId = proj.id,
ProjectName = proj.name,
Id = prol.id
}
).ToList();
return(rolesDtosLi);
}
}
public HttpResponseMessage Get(string gender = "All")
{
string username = Thread.CurrentPrincipal.Identity.Name;
using (dataEntities entities = new dataEntities())
{
switch (username.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.ToList <Employees>()));
case "male":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.Employees.Where(e => e.Gender.ToLower() == "male").ToList <Employees>()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.Employees.Where(e => e.Gender.ToLower() == "female").ToList <Employees>()));
default:
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Value for gender must be All, Male or Female." + gender + " is invaled"));
}
}
}
public ActionResult AddSet(DBtestUser emp)
{
using (dataEntities db = new dataEntities())
{
if (emp.Id == 0)
{
/*
* string fileName = Path.GetFileNameWithoutExtension(emp.Ifile.FileName);
* string extention = Path.GetExtension(emp.Ifile.FileName);
* fileName = fileName + DateTime.Now.ToString("yymmssff") + extention;
* emp.UAvatar = fileName;
* emp.Ifile.SaveAs(Path.Combine(Server.MapPath("~/AppFile/Images"), fileName));*/
db.DBtestUsers.Add(emp);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Update Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
