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);
}
