public bool Add(Majors t)
{
t.CreateDate = DateTime.Now;
var result = IMajors_BLL.Add(t);
return(result);
}
public async Task <Majors> Create(Majors majors)
{
majors.Id = Guid.NewGuid();
if (!await MajorsValidator.Create(majors))
{
return(majors);
}
try
{
await UOW.Begin();
await UOW.MajorsRepository.Create(majors);
await UOW.Commit();
return(await Get(majors.Id));
}
catch (Exception ex)
{
await UOW.Rollback();
throw new MessageException(ex);
}
}
public async Task <bool> Delete(Majors majors)
{
bool IsValid = true;
IsValid &= await IsExisted(majors);
return(IsValid);
}
public ActionResult DeleteConfirmed(int id)
{
Majors majors = db.Majors.Find(id);
db.Majors.Remove(majors);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <bool> Create(Majors majors)
{
bool IsValid = true;
IsValid &= await CodeValidate(majors);
return(IsValid);
}
private async Task <bool> IsExisted(Majors majors)
{
//Kiểm tra sự tồn tại trong DB
if (await UOW.MajorsRepository.Get(majors.Id) == null)
{
majors.AddError(nameof(MajorsValidator), nameof(majors.Name), ErrorCode.NotExisted);
}
return(majors.IsValidated);
}
public JsonResult Edit(Majors m)
{
if ((string)Session["Power"] != "1")
{
return(Json("0"));
}
MajorsDal.Edit(m);
return(Json(MajorsDal.List()));
}
public async Task<bool> Update(Majors majors)
{
await context.Majors.Where(m => m.Id == majors.Id).UpdateFromQueryAsync(m => new MajorsDAO
{
Code = majors.Code,
Name = majors.Name
});
return true;
}
public async Task <bool> Update(Majors majors)
{
await tFContext.Majors.Where(m => m.Id.Equals(majors.Id)).UpdateFromQueryAsync(m => new MajorsDAO
{
Code = majors.Code,
Name = majors.Name
});
return(true);
}
public async Task <Majors> Get(Guid Id)
{
if (Id == Guid.Empty)
{
return(null);
}
Majors majors = await UOW.MajorsRepository.Get(Id);
return(majors);
}
public ActionResult Edit([Bind(Include = "MajorID,MajorName")] Majors majors)
{
if (ModelState.IsValid)
{
db.Entry(majors).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(majors));
}
public async Task <bool> Update(Majors majors)
{
bool IsValid = true;
IsValid &= await IsExisted(majors);
IsValid &= await CodeValidate(majors);
return(IsValid);
}
public async Task <Majors> Get(Guid Id)
{
Majors Majors = await tFContext.Majors.Where(m => m.Id.Equals(Id)).Select(m => new Majors
{
Id = m.Id,
Code = m.Code,
Name = m.Name
}).FirstOrDefaultAsync();
return(Majors);
}
public ActionResult Create([Bind(Include = "MajorID,MajorName")] Majors majors)
{
if (ModelState.IsValid)
{
db.Majors.Add(majors);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(majors));
}
public async Task <Majors> Get(long Id)
{
Majors Majors = await eMSContext.Majors.Where(m => m.Id == Id).Select(m => new Majors
{
Id = m.Id,
Code = m.Code,
Name = m.Name
}).FirstOrDefaultAsync();
return(Majors);
}
private Majors ConvertDTOtoBO(MajorsDTO majorsDTO)
{
Majors majors = new Majors
{
Id = majorsDTO.Id ?? Guid.Empty,
Code = majorsDTO.Code,
Name = majorsDTO.Name,
};
return(majors);
}
public static void Add(Majors m)
{
using (var db = new XuejiContext())
{
var majors = new Majors
{
Name = m.Name
};
db.Majorses.Add(majors);
db.SaveChanges();
}
}
public static void Edit(Majors majors)
{
using (var db = new XuejiContext())
{
var single = db.Majorses.SingleOrDefault(m => m.Id == majors.Id);
if (single != null)
{
single.Name = majors.Name;
}
db.SaveChanges();
}
}
public async Task<bool> Create(Majors majors)
{
MajorsDAO majorsDAO = new MajorsDAO
{
Id = majors.Id,
Code = majors.Code,
Name = majors.Name
};
context.Majors.Add(majorsDAO);
await context.SaveChangesAsync();
return true;
}
/// <summary>
/// 新增专业
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public bool Add(Majors t)
{
try
{
var result = db.Insertable <Majors>(t).ExecuteCommand();
return(result > 0);
}
catch (Exception ex)
{
ErrorLog.WriteLog(ex);
return(false);
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Majors majors = db.Majors.Find(id);
if (majors == null)
{
return(HttpNotFound());
}
return(View(majors));
}
public void DeleteMajor(MajorModels major)
{
var users = UserProfiles.Where(u => u.Major == major).ToList();
var questions = Questions.Where(q => q.Major == major).ToList();
foreach (var u in users)
{
DeleteUser(u);
}
foreach (var q in questions)
{
DeleteQuestion(q);
}
Majors.Remove(major);
}
private void GetList()
{
int universityId = int.Parse(Helper.GetParameterFromRequest("universityId"));
Majors majors = new Majors();
MajorsRepo Repo = new MajorsRepo(majors);
if (Repo.Query(universityId))
{
Helper.Response(majors.Serialize());
}
else
{
Helper.ResponseError(Repo.ErrorMessage);
}
}
private async Task <bool> CodeValidate(Majors majors)
{
//Kiểm tra sự trùng lặp Code
MajorsFilter filter = new MajorsFilter
{
Code = new StringFilter {
Equal = majors.Code
}
};
var count = await UOW.MajorsRepository.Count(filter);
if (count > 0)
{
majors.AddError(nameof(MajorsValidator), nameof(majors.Code), ErrorCode.Duplicate);
}
return(majors.IsValidated);
}
public async Task <MajorsDTO> Get([FromBody] MajorsDTO MajorsDTO)
{
if (MajorsDTO == null)
{
MajorsDTO = new MajorsDTO();
}
Majors majors = ConvertDTOtoBO(MajorsDTO);
majors = await MajorsService.Get(majors.Id);
return(majors == null ? null : new MajorsDTO()
{
Id = majors.Id,
Code = majors.Code,
Name = majors.Name,
Errors = majors.Errors
});
}
public IEnumerable <Majors> ListMajors(out int rosterSize, int id)
{
using (var connection = new SqlConnection(this.connectionString))
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = @"DRD_Majors_List";
sqlCommand.Parameters.Add("TeamPID", SqlDbType.Int).Value = id;
SqlParameter rosterSizeOutput = new SqlParameter("@RosterSize", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
rosterSizeOutput.Size = 5000;
sqlCommand.Parameters.Add(rosterSizeOutput);
connection.Open();
sqlCommand.ExecuteNonQuery();
rosterSize = int.Parse(rosterSizeOutput.Value.ToString());
var returnMajors = new List <Majors>();
using (var reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
var majors = new Majors()
{
TeamPID = (int)reader["TeamPID"],
Player = reader["Player"] as string ?? default(string),
TeamName = reader["TeamName"] as string ?? default(string)
};
returnMajors.Add(majors);
}
}
connection.Close();
return(returnMajors);
}
}
public IActionResult Create(AddMajor model)
{
if (ModelState.IsValid)
{
var major = new Majors()
{
MajorName = model.MajorName,
FoundedYear = model.FoundedYear,
Email = model.Email,
PhoneNumber = model.PhoneNumber
};
var majorId = majorRepository.CreateMajor(major);
if (majorId > 0)
{
return(RedirectToAction("Index", "Major"));
}
ModelState.AddModelError("", "System error, please try again later!");
}
var majorView = new AddMajor();
return(View(majorView));
}
public void drop()
{
foreach (var item in Answers)
{
Answers.Remove(item);
}
foreach (var item in Questions)
{
Questions.Remove(item);
}
foreach (var item in UserProfiles)
{
UserProfiles.Remove(item);
}
foreach (var item in Majors)
{
Majors.Remove(item);
}
foreach (var item in Rates)
{
Rates.Remove(item);
}
}
public async Task <ActionResult <MajorsDTO> > Update([FromBody] MajorsDTO majorsDTO)
{
if (majorsDTO == null)
{
majorsDTO = new MajorsDTO();
}
Majors majors = ConvertDTOtoBO(majorsDTO);
majors = await MajorsService.Update(majors);
majorsDTO = new MajorsDTO
{
Id = majors.Id,
Code = majors.Code,
Name = majors.Name,
Errors = majors.Errors
};
if (majors.HasError)
{
return(BadRequest(majorsDTO));
}
return(Ok(majorsDTO));
}
public async Task <Majors> Delete(Majors majors)
{
if (!await MajorsValidator.Delete(majors))
{
return(majors);
}
try
{
await UOW.Begin();
await UOW.MajorsRepository.Delete(majors.Id);
await UOW.Commit();
return(majors);
}
catch (Exception ex)
{
await UOW.Rollback();
throw new MessageException(ex);
}
}
// Use this for initialization
void Start()
{
mainCam = GameObject.FindGameObjectWithTag("MainCamera").GetComponent<Camera>();
students = new List<GameObject>();
names = GetComponent<Names>();
taglines = GetComponent<Taglines>();
majors = GetComponent<Majors>();
//load character parts from resources folder into arrays
bodies = System.Array.ConvertAll( Resources.LoadAll("Bodies", typeof(GameObject)),o=>(GameObject)o);
heads = System.Array.ConvertAll(Resources.LoadAll("Heads", typeof(GameObject)), o => (GameObject)o);
clothes = System.Array.ConvertAll(Resources.LoadAll("Clothes", typeof(GameObject)), o => (GameObject)o);
hairs = System.Array.ConvertAll(Resources.LoadAll("Hairs", typeof(GameObject)), o => (GameObject)o);
}
