public override Result <int> Delete(int id)
{
Member m = db.Members.SingleOrDefault(t => t.UserId == id);
db.Members.Remove(m);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
User delUser = _db.Users.SingleOrDefault(t => t.Id == id);
_db.Users.Remove(delUser);
return(result.GetResult(_db));
}
public override Result <int> Delete(int id)
{
Brand silinecek = db.Brands.SingleOrDefault(t => t.BrandId == id);
db.Brands.Remove(silinecek);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Brand b = db.Brands.SingleOrDefault(x => x.BrandId == id);
db.Brands.Remove(b);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Comment com = db.Comments.SingleOrDefault(x => x.CommentID == id);
db.Comments.Remove(com);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
List <OrderDetail> OdList = db.OrderDetails.Where(t => t.OrderId == id).ToList();
db.OrderDetails.RemoveRange(OdList);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Product silinecek = db.Products.SingleOrDefault(t => t.ProductId == id);
db.Products.Remove(silinecek);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Category delCat = _db.Categories.SingleOrDefault(t => t.CategoryId == id);
_db.Categories.Remove(delCat);
return(result.GetResult(_db));
}
public override Result <int> Insert(UserInfo item)
{
item.ilanSayisi = 0;
item.UserUyeDate = DateTime.Now;
db.UserInfoes.Add(item);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Tag delTag = _db.Tags.SingleOrDefault(t => t.Id == id);
_db.Tags.Remove(delTag);
return(result.GetResult(_db));
}
public override Result <int> Delete(Guid id)
{
Category c = db.Categories.SingleOrDefault(t => t.CategoryId == id);
db.Categories.Remove(c);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Order deleted = db.Orders.SingleOrDefault(t => t.OrderId == id);
db.Orders.Remove(deleted);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Comment delCom = _db.Comments.SingleOrDefault(t => t.Id == id);
_db.Comments.Remove(delCom);
return(result.GetResult(_db));
}
public override Result <int> Debit(int Id, Product item)
{
Product p = db.Products.SingleOrDefault(pr => pr.ProductID == Id);
Employee e = db.Employees.SingleOrDefault(er => er.EmployeeID == item.EmployeeID);
e.Products.Add(p);
p.EmployeeID = item.EmployeeID;
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Ilanlar sil = db.Ilanlars.SingleOrDefault(t => t.İlanId == id);
sil.UserInfo.ilanSayisi--;
ur.Update(sil.UserInfo);
db.Ilanlars.Remove(sil);
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Article delArt = _db.Articles.SingleOrDefault(t => t.Id == id);
_db.Articles.Remove(delArt);
//var tagDelete = from arTag in _db.Tags
// where arTag.Article_ID == id
// select arTag;
//foreach (var tag in tagDelete)
//{
// _db.Tags.Remove(tag);
//}
return(result.GetResult(_db));
}
public override Result <int> Delete(int id)
{
Adress ad = db.Adresses.SingleOrDefault(a => a.AdressId == id);
if (ad.Employees.Count == 0)
{
db.Adresses.Remove(ad);
}
else
{
ad.Employees.Clear();
db.Adresses.Remove(ad);
}
return(result.GetResult(db));
}
public override Result <int> Delete(int id)
{
Employee emp = db.Employees.SingleOrDefault(e => e.EmployeeID == id);
if (emp.Products.Count == 0 && emp.Adresses.Count == 0)
{
db.Employees.Remove(emp);
return(result.GetResult(db));
}
else
{
emp.Adresses.Clear();
emp.Products.Clear();
db.Employees.Remove(emp);
return(result.GetResult(db));
}
}
public override Result <int> Delete(int id)
{
Product silinecek = db.Products.SingleOrDefault(t => t.ProductId == id);
string fullPath = AppDomain.CurrentDomain.BaseDirectory + "\\Upload\\";
foreach (string item in silinecek.Photo.Split(','))
{
if (item == "" || item == " ")
{
continue;
}
File.Delete(fullPath + item);
}
db.Products.Remove(silinecek);
return(result.GetResult(db));
}
public Result <int> Insert(List <CourseStudent> gelenStudentList, List <CourseStudent> gelmeyenStudentList, User user)
{
Teacher tchr = db.Teachers.FirstOrDefault(t => t.UserId == user.UserId);
foreach (var item in gelenStudentList)
{
//(int)DateTime.Now.DayOfWeek
AttendanceLog al = new AttendanceLog();
al.TeacherId = tchr.TeacherId;
al.CourseStudentId = item.Id;
al.Date = DateTime.Now;
al.IsOnline = 1;
al.IsFingerprint = 0;
al.IsSchoolCard = 0;
db.AttendanceLogs.Add(al);
}
foreach (var item in gelmeyenStudentList)
{
AttendanceLog al = new AttendanceLog();
al.TeacherId = tchr.TeacherId;
al.CourseStudentId = item.Id;
al.Date = DateTime.Now;
al.IsOnline = 0;
al.IsFingerprint = 0;
al.IsSchoolCard = 0;
db.AttendanceLogs.Add(al);
CourseStudent cs = db.CourseStudents.FirstOrDefault(t => t.Id == al.CourseStudentId);
cs.AttendanceSum = cs.AttendanceSum + 1;
Course getCourse = db.Courses.FirstOrDefault(t => t.Id == cs.CourseId);
if (cs.AttendanceSum < (getCourse.LecturePerWeek * 14 * 30 / 100) - 2)
{
cs.AttendanceSituation = 1;
}
else if ((getCourse.LecturePerWeek * 14 * 30 / 100) - 2 <= cs.AttendanceSum &&
cs.AttendanceSum <= (getCourse.LecturePerWeek * 14 * 30 / 100))
{
cs.AttendanceSituation = 2;
}
else if ((getCourse.LecturePerWeek * 14 * 30 / 100) < cs.AttendanceSum)
{
cs.AttendanceSituation = 3;
}
db.CourseStudents.Update(cs);
}
return(result.GetResult(db));
}
public override Result <int> Insert(Invoice item)
{
db.Invoices.Add(item);
return(result.GetResult(db));
}
public override Result <int> Insert(Reply item)
{
item.ReplyDate = DateTime.Now;
_db.Replies.Add(item);
return(result.GetResult(_db));
}
public override Result <int> Insert(Branslar item)
{
db.Branslars.Add(item);
return(result.GetResult(db));
}
