public ResponseBase InsertOrUpdate(string connectString, MajorModel model)
{
using (db = new QMSSystemEntities(connectString))
{
try
{
var rs = new ResponseBase();
if (CheckExists(model.Id, model.Name.Trim().ToUpper()))
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "Insert", Message = "Tên nghiệp vụ này đã được sử dụng. Vui lòng nhập Tên khác !."
});
}
else
{
Q_Major obj;
if (model.Id == 0)
{
obj = new Q_Major();
Parse.CopyObject(model, ref obj);
db.Q_Major.Add(obj);
rs.IsSuccess = true;
}
else
{
obj = db.Q_Major.FirstOrDefault(m => m.Id == model.Id);
if (obj == null)
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "Update", Message = "Dữ liệu bạn đang thao tác đã bị xóa hoặc không tồn tại. Vui lòng kiểm tra lại !."
});
}
else
{
obj.Name = model.Name;
obj.IsShow = model.IsShow;
obj.Note = model.Note;
rs.IsSuccess = true;
}
}
if (rs.IsSuccess)
{
db.SaveChanges();
rs.IsSuccess = true;
}
}
return(rs);
}
catch (Exception ex)
{
throw ex;
}
}
}
public int DeleMajor(MajorModel mm)
{
Major m = new Major()
{
Id = mm.Id
};
return(Delete(m));
}
public ActionResult MajorDele(int Id)
{
MajorModel mm = new MajorModel()
{
Id = Id
};
return(Content(JsonConvert.SerializeObject(im.DeleMajor(mm))));
}
public async Task <ActionResult> DeleteConfirmed(string id)
{
MajorModel majorModel = await db.Majors.FindAsync(id);
db.Majors.Remove(majorModel);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public int AddMajor(MajorModel mm)
{
Major m = new Major()
{
MCID = mm.MCID,
MKID = mm.MKID
};
return(Add(m));
}
public ActionResult MajorInsert2(int MKID, int MCID)
{
MajorModel mm = new MajorModel()
{
MCID = MCID,
MKID = MKID
};
return(Content(JsonConvert.SerializeObject(im.AddMajor(mm))));
}
public async Task <ActionResult> Edit([Bind(Include = "MajorID,MajorName,CollegeName,Duration,Level,Requirements")] MajorModel majorModel)
{
if (ModelState.IsValid)
{
db.Entry(majorModel).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.CollegeName = new SelectList(db.Colleges, "CollegeID", "CollegeName", majorModel.CollegeName);
return(View(majorModel));
}
public PrintPlanViewModel(ISqlData sqlData, MajorModel major)
{
_sqlData = sqlData;
_major = major;
if (major != null)
{
PrintYearOne = new BindableCollection <CourseModel>(_sqlData.GetPrintCourses(UserName, major.MajorId, 1));
PrintYearTwo = new BindableCollection <CourseModel>(_sqlData.GetPrintCourses(UserName, major.MajorId, 2));
PrintYearThree = new BindableCollection <CourseModel>(_sqlData.GetPrintCourses(UserName, major.MajorId, 3));
MajorName = _major.Name;
}
}
public async Task <ActionResult> Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MajorModel majorModel = await db.Majors.FindAsync(id);
if (majorModel == null)
{
return(HttpNotFound());
}
return(View(majorModel));
}
public async Task <ActionResult> Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MajorModel majorModel = await db.Majors.FindAsync(id);
if (majorModel == null)
{
return(HttpNotFound());
}
ViewBag.CollegeName = new SelectList(db.Colleges, "CollegeID", "CollegeName", majorModel.CollegeName);
return(View(majorModel));
}
public SelectElectivesViewModel(ISqlData sqlData, IEventAggregator eventAggregator, MajorModel major)
{
_sqlData = sqlData;
_eventAggregator = eventAggregator;
_major = major;
if (major != null)
{
_electiveCourses = new BindableCollection <CourseModel>(_sqlData.GetAllElectiveCourses(UserName, major.MajorId));
_completedCourses = new List <CompletedCourseModel>(_sqlData.GetAllCompletedCourses(UserName));
_creditsCompleted = _sqlData.GetCreditsCompleted(UserName, major.MajorId).FirstOrDefault();
_creditsDue = 360;
MajorName = _major.Name;
}
}
public List <MajorModel> GetAll()
{
List <MajorModel> majorModels = new List <MajorModel>();
using (conn = JBCertConnection.Instance)
{
string queryString = "Select * From [dbo].[tblNganhDaoTao] Where IsDeleted = 0";
conn.Open();
SqlCommand sqlCommand = new SqlCommand(queryString, conn);
sqlCommand.CommandType = CommandType.Text;
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
try
{
while (sqlDataReader.Read())
{
MajorModel majorModel = new MajorModel();
majorModel.Id = int.Parse(sqlDataReader["Id"].ToString());
majorModel.MajorName = sqlDataReader["Nganhdaotao"].ToString();
majorModel.Note = sqlDataReader["Note"].ToString();
majorModel.IsDeleted = false;
majorModels.Add(majorModel);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlDataReader.Close();
conn.Close();
}
}
return(majorModels);
}
public JsonResult Save(MajorModel model)
{
ResponseBase res = new ResponseBase();
try
{
res = BLLMajor.Instance.InsertOrUpdate(AppGlobal.Connectionstring, model);
if (!res.IsSuccess)
{
JsonDataResult.Result = "ERROR";
JsonDataResult.ErrorMessages.AddRange(res.Errors);
}
else
{
JsonDataResult.Result = "OK";
}
}
catch (Exception ex)
{
throw (ex);
}
return(Json(JsonDataResult));
}
public void Handle(MajorModel message)
{
ChosenMajor = message;
}
public int DeleMajor(MajorModel mm)
{
return(im.DeleMajor(mm));
}
public int AddMajor(MajorModel mm)
{
return(im.AddMajor(mm));
}
