public bool Insert(ExpertsDetailtObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_ExpertsDetailt_INSERT(ob.ExId, ob.ExpertId, ob.CoId, ob.Description); return(true); }
public bool Delete(Guid ID) { var db = new eTrainingScheduleEntities(); var Data = db.sp_tbl_S07_ExpertsDetailt_DELETE(ID); return(true); }
public List <CoursesJournalObjects> GetJoin() { List <CoursesJournalObjects> lst = new List <CoursesJournalObjects>(); var db = new eTrainingScheduleEntities(); var list = db.sp_CoursesJournal_Join(); foreach (var item in list) { CoursesJournalObjects ob = new CoursesJournalObjects(); ob.CJId = item.CJId; ob.CoId = item.CoId; ob.DayOf = item.DayOf; ob.Contents = item.Contents; ob.Description = item.DescriptionCoursesJournal; ob.CoursesJoin = new CoursesObjects() { CoId = (Guid)item.CoId, CourseId = item.CourseId, CourseName = item.CourseName, Deleted = item.Deleted, Description = item.DescriptionCourses, EndDate = item.EndDate, StartDate = item.StartDate, Status = item.Status == true, TotalNumber = item.TotalNumber }; lst.Add(ob); } return(lst); }
public bool Insert(CoursesJournalObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_CoursesJournal_INSERT(ob.CJId, ob.CoId, ob.DayOf, ob.Contents, ob.Description); return(true); }
public List <PermisstionObject> GetJoinCheck(Guid UserID, string FeaID) { List <PermisstionObject> lst = new List <PermisstionObject>(); var db = new eTrainingScheduleEntities(); var list = db.WEB_QLGD01_sp_Permission_GetJoinCheck(UserID, FeaID); foreach (var item in list) { PermisstionObject ob = new PermisstionObject(); ob.PerID = item.PerID; ob.F_ADD = item.F_ADD == true; ob.F_EDIT = item.F_EDIT == true; ob.F_DELETE = item.F_DELETE == true; ob.F_SEARCH = item.F_SEARCH == true; ob.FeaId = item.FeaId; ob.UserId = item.UserId; ob.FeaJoin = new FeaIdObject() { FeaId = item.FeaId, FeaName = item.FeaName, Isdeleted = item.IsdeletedFedId }; ob.AccountJoin = new AccountObject { Description = item.Description, Email = item.Email, FullName = item.FullName, Isdeleted = item.IsdeletedAccount, PassWord = item.PassWord, Phone = item.Phone, RoleId = item.RoleId, UserId = item.UserId, Username = item.Username }; lst.Add(ob); } return(lst); }
public bool Delete(Guid ID) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_CoursesJournal_DELETE(ID); return(true); }
public bool Insert(CoursesObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_Courses_INSERT(ob.CoId, ob.CourseId, ob.CourseName, ob.TotalNumber, ob.StartDate, ob.EndDate, ob.Status, ob.Description, ob.Deleted); return(true); }
public bool Insert(SchedulersObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_Schedulers_INSERT(ob.ScId, ob.WeId, ob.ShiftId, ob.CoId, ob.Description); return(true); }
public bool Insert(ExpertsObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_Experts_INSERT(ob.ExpertId, ob.FullName, ob.Email, ob.Mobile, ob.Address, ob.Specialize, ob.StartDate, ob.Status, ob.Description, ob.Deleted); return(true); }
public bool Delete(Guid id) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_Experts_DELETE(id); return(true); }
public bool Insert(StudentObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_Student_INSERT(ob.StudetId, ob.FullName, ob.Email, ob.Mobile, ob.Address, ob.Status, ob.Deleted); return(true); }
public bool UPDATE(NotificationsObjects obj) { var da = new eTrainingScheduleEntities().sp_tbl_Notifications_UPDATE(obj.notificationsID, obj.UserId, obj.title, obj.Content, obj.status, obj.UserId2, obj.StartDate, obj.Isdeleted ); return(true); }
public bool Insert(CoursesStudentDetailtObject ob) { ob.ScsId = Guid.NewGuid(); var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_CoursesStudentDetailt_INSERT(ob.ScsId, ob.StudetId, ob.CJId, ob.Description); return(true); }
public bool Delete(Guid ID) { var db = new eTrainingScheduleEntities(); var obj = GetByRoleId(ID); obj.Isdeleted = true; Update(obj); return(true); }
public bool Insert(AccountObject ob) { if (GetAll().Find(q => q.Username.Trim().ToLower() == ob.Username) != null) { return(false); } var db = new eTrainingScheduleEntities(); return(db.sp_tbl_Account_INSERT(ob.UserId, ob.FullName, ob.PassWord, ob.Username, ob.Email, ob.Phone, ob.Description, ob.Isdeleted, ob.RoleId) > 0); }
public bool Delete(string ID) { var db = new eTrainingScheduleEntities(); var obj = GetByFeaId(ID); if (obj == null) { return(false); } obj.Isdeleted = true; return(Update(obj)); }
public CoursesStudentDetailtObject GetByStudetId(Guid ID) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_CoursesStudentDetailt_GetByStudetId(ID); CoursesStudentDetailtObject obj = new CoursesStudentDetailtObject(); foreach (var item in list) { obj.ScsId = item.ScsId; obj.StudetId = item.StudetId; obj.CJId = item.CJId; obj.Description = item.Description; } return(obj); }
public bool Delete(Guid ID) { var db = new eTrainingScheduleEntities(); var ob = GetByCoId(ID); if (ob == null) { return(false); } ob.Deleted = true; return(Update(ob)); }
public PermisstionObject GetByPerID(Guid ID) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_Permisstion_GetByPerID(ID); foreach (var item in list) { PermisstionObject obj = new PermisstionObject(); obj.PerID = item.PerID; obj.F_ADD = item.F_ADD; obj.F_EDIT = item.F_EDIT; obj.F_DELETE = item.F_DELETE; obj.F_SEARCH = item.F_SEARCH; obj.FeaId = item.FeaId; obj.UserId = item.UserId; return(obj); } return(null); }
public ShiftDayObjects GetByShiftId(Guid ob) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_ShiftDay_GetByShiftId(ob); foreach (var item in list) { ShiftDayObjects obj = new ShiftDayObjects(); obj.ShiftId = item.ShiftId; obj.ShiftName = item.ShiftName; obj.Description = item.Description; return(obj); } return(null); }
public ExpertsDetailtObjects GetByExId(Guid ExId) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_ExpertsDetailt_GetByExId(ExId); foreach (var item in list) { ExpertsDetailtObjects obj = new ExpertsDetailtObjects(); obj.ExId = item.ExId; obj.ExpertId = item.ExpertId; obj.CoId = item.CoId; obj.Description = item.Description; return(obj); } return(null); }
public CoursesJournalObjects GetByCJId(Guid ob) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_CoursesJournal_GetByCJId(ob); foreach (var item in list) { CoursesJournalObjects obj = new CoursesJournalObjects(); obj.CJId = item.CJId; obj.CoId = item.CoId; obj.DayOf = item.DayOf; obj.Contents = item.Contents; obj.Description = item.Description; return(obj); } return(null); }
public StudentDetailtObjects GetByStdId(StudentDetailtObjects ob) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_StudentDetailt_GetByStdId(ob.StdId); foreach (var item in list) { StudentDetailtObjects obj = new StudentDetailtObjects(); obj.StdId = item.StdId; obj.StudetId = item.StudetId; obj.CoId = item.CoId; obj.Description = item.Description; return(obj); } return(null); }
public AccountObject CheckLogin(AccountObject obj) { var db = new eTrainingScheduleEntities(); var list = db.sp_Account_CheckLogin(obj.Username, obj.PassWord); foreach (var item in list) { AccountObject ob = new AccountObject(); ob.UserId = item.UserId; ob.FullName = item.FullName; ob.PassWord = item.PassWord; ob.Username = item.Username; ob.Email = item.Email; ob.Phone = item.Phone; ob.Description = item.Description; ob.Isdeleted = item.Isdeleted; ob.RoleId = item.RoleId; return(ob); } return(null); }
public WeekdaysObjects GetByWeId(WeekdaysObjects ob) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_Weekdays_GetByWeId(ob.WeId); foreach (var item in list) { WeekdaysObjects obj = new WeekdaysObjects(); obj.WeId = item.WeId; obj.WeName = item.WeName; obj.Description = item.Description; return(obj); } return(null); }
public ExpertsObjects GetByExpertId(Guid ID) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_Experts_GetByExpertId(ID); foreach (var item in list) { ExpertsObjects obj = new ExpertsObjects(); obj.ExpertId = item.ExpertId; obj.FullName = item.FullName; obj.Email = item.Email; obj.Mobile = item.Mobile; obj.Address = item.Address; obj.Specialize = item.Specialize; obj.StartDate = item.StartDate; obj.Status = item.Status == true; obj.Description = item.Description; obj.Deleted = item.Deleted; return(obj); } return(null); }
public CoursesObjects GetByCoId(Guid ID) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_Courses_GetByCoId(ID); foreach (var item in list) { CoursesObjects obj = new CoursesObjects(); obj.CoId = item.CoId; obj.CourseId = item.CourseId; obj.CourseName = item.CourseName; obj.TotalNumber = item.TotalNumber; obj.StartDate = item.StartDate; obj.EndDate = item.EndDate; obj.Status = item.Status == true; obj.Description = item.Description; obj.Deleted = item.Deleted; return(obj); } return(null); }
public bool Delete(Guid ID) { /*var db = new eTrainingScheduleEntities(); * var ob = GetByStudetId(ID); * if (ob == null) return false; * ob.Deleted = true; * Update(ob); * return true;*/ var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_Student_DELETE(ID); return(true); }
public RoleObject GetByRoleId(Guid ID) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_Role_GetByRoleId(ID); foreach (var item in list) { RoleObject obj = new RoleObject(); obj.RoleId = item.RoleId; obj.RName = item.RName; obj.Isdeleted = item.Isdeleted; return(obj); } return(null); }
public FeaIdObject GetByFeaId(string ID) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_FeaId_GetByFeaId(ID); foreach (var item in list) { FeaIdObject obj = new FeaIdObject(); obj.FeaId = item.FeaId; obj.FeaName = item.FeaName; obj.Isdeleted = item.Isdeleted; return(obj); } return(null); }