public IHttpActionResult PostClass([FromBody] ClassRequest classRequest)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var student = db.Students.FirstOrDefault(x => x.IndexNumber == classRequest.StudentId);
var studentClass = new StudentClassesEntity
{
ClassId = classRequest.ClassId,
StudentId = student.Id
};
var ctx = new EfDbContext();
try
{
ctx.ClassesEntities.Add(studentClass);
ctx.SaveChanges();
}
catch (Exception e)
{
return(BadRequest(e.ToString()));
}
finally
{
ctx.Dispose();
}
return(CreatedAtRoute("DefaultApi", new { id = classRequest.StudentId }, classRequest));
}
public async void UpdateClassSuccessful()
{
var model = new ClassRequest()
{
@class = "testName1",
subject = "testSubject1",
teacher = "testUser",
students = new List <string> {
"testUser1", "TestUser2", "TestUser3"
}
};
var result = await _SemetserService.Object.AddClass(1, model);
Assert.Equal((int)HttpStatusCode.OK, ((ObjectResult)result).StatusCode);
var models = new List <ClassRequest>();
models.Add(new ClassRequest()
{
id = "2",
@class = "testName2",
subject = "testSubject3",
teacher = "testUser",
students = new List <string> {
"testUser1", "TestUser2", "TestUser3"
}
});
result = await _SemetserService.Object.UpdateClass(1, models);
Assert.Equal((int)HttpStatusCode.OK, ((ObjectResult)result).StatusCode);
var response = RoomDAO.Get(roomContext, 2);
Assert.Equal(response.ClassName, "testName2");
Assert.Equal(response.Subject, "testSubject3");
}
public async Task <ClassResponse> Create(ClassRequest request)
{
try
{
var _class = await _context.Classes.AddAsync(new Class
{
SchoolId = request.SchoolId,
Name = request.Name,
});
await _context.SaveChangesAsync();
return(new ClassResponse
{
Id = _class.Entity.Id,
Name = _class.Entity.Name,
CreatedDate = _class.Entity.CreatedDate,
School = _class.Entity.School
});
}
catch (Exception ex)
{
throw new DatabaseException(ex.Message);
}
}
public async Task <object> Get()
{
ClassRequest msg = new ClassRequest();
var a = await msg.GetDataAsync();
return(a);
}
private void btnprint_Click(object sender, EventArgs e)
{
RPT.RRM_Reports frm = new RPT.RRM_Reports();
RPT.rpt_print_requset rpr = new RPT.rpt_print_requset();
rpr.SetParameterValue("@req_id", ClassRequest.max_id());
frm.crystalReportViewer1.ReportSource = rpr;
frm.ShowDialog();
}
public GetResult GetResultOfClass(ClassRequest classRequest)
{
IEnumerable <GetResultOfClass> data;
GetResult getResult = new GetResult();
data = (from result in _ObjContext.Result
join exhibitor in _ObjContext.Exhibitors on result.ExhibitorId equals exhibitor.ExhibitorId into exhibitor1
from exhibitor2 in exhibitor1.DefaultIfEmpty()
join exhibitorsClass in _ObjContext.ExhibitorClass on exhibitor2.ExhibitorId equals exhibitorsClass.ExhibitorId into exhibitorsClass1
from exhibitorsClass2 in exhibitorsClass1.DefaultIfEmpty()
join addresses in _ObjContext.Addresses on exhibitor2.AddressId equals addresses.AddressId into addresses1
from addresses2 in addresses1.DefaultIfEmpty()
join city in _ObjContext.Cities on addresses2.CityId equals city.CityId into city1
from city2 in city1.DefaultIfEmpty()
join state in _ObjContext.States on city2.StateId equals state.StateId into state1
from state2 in state1.DefaultIfEmpty()
join zipcode in _ObjContext.ZipCodes2 on addresses2.ZipCodeId equals zipcode.ZipCodeId into zipcode1
from zipcode2 in zipcode1.DefaultIfEmpty()
where result.IsActive == true && result.IsDeleted == false && exhibitor2.IsActive == true && exhibitor2.IsDeleted == false &&
exhibitorsClass2.IsDeleted == false && exhibitorsClass2.ClassId == classRequest.ClassId &&
result.ClassId == classRequest.ClassId
select new GetResultOfClass
{
ResultId = result.ResultId,
ExhibitorId = exhibitor2.ExhibitorId,
Place = result.Placement,
BackNumber = exhibitor2.BackNumber,
ExhibitorName = exhibitor2.FirstName + " " + exhibitor2.LastName,
BirthYear = exhibitor2.BirthYear,
HorseName = _ObjContext.Horses.Where(x => x.HorseId == exhibitorsClass2.HorseId && x.IsDeleted == false).Select(x => x.Name).FirstOrDefault(),
Address = city2.Name + ", " + state2.Code + " ," + zipcode2.ZipCode
}).Distinct().ToList();
if (data.Count() != 0)
{
if (classRequest.OrderByDescending == true)
{
data = data.OrderByDescending(x => x.GetType().GetProperty(classRequest.OrderBy).GetValue(x));
}
else
{
data = data.OrderBy(x => x.GetType().GetProperty(classRequest.OrderBy).GetValue(x));
}
getResult.TotalRecords = data.Count();
if (classRequest.AllRecords)
{
getResult.getResultOfClass = data.ToList();
}
else
{
getResult.getResultOfClass = data.Skip((classRequest.Page - 1) * classRequest.Limit).Take(classRequest.Limit).ToList();
}
}
return(getResult);
}
public void AddClassToStudent(ClassRequest classRequest)
{
var cls = new Class {
Id = classRequest.ClassId, StartDateTime = DateTime.Today
};
cls.Students.Add(new Student {
Id = classRequest.StudentId
});
_classRepository.Add(cls);
}
protected override bool isValid(out string exceptionMessage)
{
if (name.Length == 0) {
return makeExceptionMessage (out exceptionMessage, "The name of the class is invalid");
}
ClassRequest cr = new ClassRequest ();
if (cr.fetchClassFromName (name).Count != 0) {
return makeExceptionMessage(out exceptionMessage, "The name of the class already exists");
}
return makeExceptionMessage(out exceptionMessage);
}
public IHttpActionResult Get([FromBody] ClassRequest clsReq)
{
try
{
ScheduleManager s = new ScheduleManager();
return(Ok(s.GetScheduleByClass(clsReq.ClsId)));//TODO with date
}
catch (Exception e)
{
LogManager.LogException(e);
return(InternalServerError(e));
}
}
public void Remove()
{
// Web Service of the Entity to be used
Sync.WMS.WMSDataImportWS.ClassRequest wsEntity = new ClassRequest();
//Required Fields
wsEntity.ERPCompany = "DEMOWMS510";
wsEntity.Code = "AA";
//Saving
object result;
result = m_WSClient.DeleteClass(wsEntity);
}
public async void AddClassFailClassAlreadyExist()
{
var model = new ClassRequest()
{
@class = "testName",
subject = "testSubject",
teacher = "testUser",
students = new List <string> {
"testUser1", "TestUser2", "TestUser3"
}
};
var result = await _SemetserService.Object.AddClass(1, model);
Assert.Equal((int)HttpStatusCode.BadRequest, ((ObjectResult)result).StatusCode);
}
public GetAllClasses GetAllClasses(ClassRequest classRequest)
{
IEnumerable <ClassResponse> data;
GetAllClasses getAllClasses = new GetAllClasses();
data = (from classes in _ObjContext.Classes
where classes.IsDeleted == false && classes.IsActive == true
orderby classes.ClassNumber
select new ClassResponse
{
ClassId = classes.ClassId,
Classnum = Convert.ToInt32(Regex.Match(classes.ClassNumber, @"\d+").Value),
ClassNumber = classes.ClassNumber,
Name = classes.Name,
Entries = classes != null ? _ObjContext.ExhibitorClass.Where(x => x.ClassId == classes.ClassId && x.IsActive == true && x.IsDeleted == false).Select(x => x.ExhibitorClassId).Count():0,
AgeGroup = classes.AgeGroup,
});
data = data.OrderBy(x => x.Classnum);
if (data.Count() != 0)
{
if (classRequest.SearchTerm != null && classRequest.SearchTerm != "")
{
data = data.Where(x => x.ClassNumber.Contains(classRequest.SearchTerm) || x.Name.ToLower().Contains(classRequest.SearchTerm.ToLower()) ||
Convert.ToString(x.Entries).Contains(classRequest.SearchTerm));
}
if (classRequest.OrderByDescending == true)
{
data = data.OrderByDescending(x => x.ClassNumber);
data = data.OrderByDescending(x => x.GetType().GetProperty(classRequest.OrderBy).GetValue(x));
}
else
{
data = data.OrderBy(x => x.GetType().GetProperty(classRequest.OrderBy).GetValue(x));
}
getAllClasses.TotalRecords = data.Count();
if (classRequest.AllRecords)
{
getAllClasses.classesResponse = data.ToList();
}
else
{
getAllClasses.classesResponse = data.Skip((classRequest.Page - 1) * classRequest.Limit).Take(classRequest.Limit).ToList();
}
}
return(getAllClasses);
}
public async Task <ClassResponse> AddClassAsync(ClassRequest clsR)
{
var cls = await _classRepository.GetSingleAsync(c => c.ClassName == clsR.ClassName);
if (cls == null)
{
var clas = new Models.Class
{
ClassName = clsR.ClassName
};
if (await _classRepository.InsertAsync(clas))
{
return(clas.Map <ClassResponse>());
}
}
throw new Exception();
}
public MainResponse GetAllClasses(ClassRequest classRequest)
{
var allClasses = _classRepository.GetAllClasses(classRequest);
if (allClasses != null && allClasses.TotalRecords != 0)
{
_mainResponse.GetAllClasses = allClasses;
_mainResponse.GetAllClasses.TotalRecords = allClasses.TotalRecords;
_mainResponse.Success = true;
}
else
{
_mainResponse.Message = Constants.NO_RECORD_FOUND;
_mainResponse.Success = false;
}
return(_mainResponse);
}
public MainResponse GetResultOfClass(ClassRequest classRequest)
{
var getResult = _classRepository.GetResultOfClass(classRequest);
if (getResult != null && getResult.TotalRecords != 0)
{
_mainResponse.GetResult = getResult;
_mainResponse.GetResult.TotalRecords = getResult.TotalRecords;
_mainResponse.Success = true;
}
else
{
_mainResponse.Message = Constants.NO_RECORD_FOUND;
_mainResponse.Success = false;
}
return(_mainResponse);
}
private void btnsave_Click(object sender, EventArgs e)
{
try
{
DataTable reqdet = new DataTable();
reqdet.Columns.Add("P_ID");
reqdet.Columns.Add("Qty");
reqdet.Columns.Add("P_Price");
foreach (DataGridViewRow dr in dgvProduct.Rows)
{
reqdet.Rows.Add(dr.Cells[0].Value, dr.Cells[4].Value, dr.Cells[3].Value);
}
DataTable dtexpired = new DataTable();
dtexpired.Columns.Add("Ex_Date");
dtexpired.Columns.Add("P_ID");
dtexpired.Columns.Add("Qty");
foreach (DataGridViewRow dr in dgvProduct.Rows)
{
string expired;
if (dr.Cells[2].Value.ToString() == "")
{
expired = null;
}
else
{
expired = dr.Cells[2].Value.ToString();
}
dtexpired.Rows.Add(DateTime.Parse(expired), dr.Cells[0].Value, dr.Cells[4].Value);
}
ClassRequest.sp_request_insert(reqdate.Value.Date, txttotal.Text,
int.Parse(txtSupID.Text), txtBuyerName.Text, reqdet, dtexpired);
MessageBox.Show("تم عملية الحفظ بنجاح");
btnprint.Enabled = btnnewPruchase.Enabled = true;
btnsave.Enabled = btnDelete.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show("البيانات غير كافية لحفظ الفاتورة");
}
}
public GetAllClassEntries GetClassEntries(ClassRequest classRequest)
{
IEnumerable <GetClassEntries> data;
GetAllClassEntries getAllClassEntries = new GetAllClassEntries();
data = (from exhibitorclasses in _ObjContext.ExhibitorClass
join exhibitors in _ObjContext.Exhibitors on exhibitorclasses.ExhibitorId equals exhibitors.ExhibitorId into exhibitors1
from exhibitors2 in exhibitors1.DefaultIfEmpty()
join horses in _ObjContext.Horses on exhibitorclasses.HorseId equals horses.HorseId into horses1
from horses2 in horses1.DefaultIfEmpty()
where exhibitorclasses.IsDeleted == false && exhibitors2.IsDeleted == false && exhibitorclasses.IsActive == true && exhibitors2.IsActive == true &&
horses2.IsDeleted == false && horses2.IsActive == true &&
exhibitorclasses.ClassId == classRequest.ClassId
select new GetClassEntries
{
ExhibitorClassId = exhibitorclasses.ExhibitorClassId,
Exhibitor = exhibitors2.ExhibitorId + " " + exhibitors2.FirstName + " " + exhibitors2.LastName,
Horse = horses2.Name,
BirthYear = exhibitors2.BirthYear,
Scratch = exhibitorclasses.IsScratch
}).Distinct().ToList();
if (data.Count() != 0)
{
if (classRequest.OrderByDescending == true)
{
data = data.OrderByDescending(x => x.GetType().GetProperty(classRequest.OrderBy).GetValue(x));
}
else
{
data = data.OrderBy(x => x.GetType().GetProperty(classRequest.OrderBy).GetValue(x));
}
getAllClassEntries.TotalRecords = data.Count();
if (classRequest.AllRecords)
{
getAllClassEntries.getClassEntries = data.ToList();
}
else
{
getAllClassEntries.getClassEntries = data.Skip((classRequest.Page - 1) * classRequest.Limit).Take(classRequest.Limit).ToList();
}
}
return(getAllClassEntries);
}
public async void AddClass()
{
var model = new ClassRequest()
{
@class = "testName1",
subject = "testSubject1",
teacher = "testUser",
students = new List <string> {
"testUser1", "TestUser2", "TestUser3"
}
};
var result = await _SemetserService.Object.AddClass(1, model);
Assert.Equal((int)HttpStatusCode.OK, ((ObjectResult)result).StatusCode);
var response = ((ObjectResult)result).Value as ClassResponse;
Assert.Equal(response.@class, "testName1");
Assert.Equal(response.subject, "testSubject1");
}
protected void Insert_Click(object sender, EventArgs e)
{
ClassRequest r = new ClassRequest();
r.CITIZEN_ID = txt4.Text;
//r.RANK_ID = Convert.ToInt32(ddl5.SelectedValue);
r.TITLE_ID = Convert.ToInt32(ddl6.SelectedValue);
r.NAME = txt1.Text;
r.LASTNAME = txt2.Text;
r.GENDER_ID = Convert.ToInt32(ddl7.SelectedValue);
r.BIRTHDATE = DateTime.Parse(txt3.Text);
r.STAFFTYPE_ID = Convert.ToInt32(ddl1.SelectedValue);
r.FACULTY_ID = Convert.ToInt32(ddl2.SelectedValue);
r.GRADEINSIGNIA_ID = Convert.ToInt32(ddl7.SelectedValue);
r.STARTING_DATE = DateTime.Parse(txt5.Text);
r.STARTING_POSITION_ID = Convert.ToInt32(ddl8.SelectedValue);
// r.CURRENT_POSITION = ddl9.SelectedValue;
r.CURRENT_SALARY = Convert.ToInt32(txt6.Text);
string[] splitDate1 = txt3.Text.Split(' ');
string[] splitDate2 = txt5.Text.Split(' ');
if (splitDate1.Length == 4)
{
splitDate1[2] = splitDate1[3];
}
if (splitDate2.Length == 4)
{
splitDate2[2] = splitDate2[3];
}
r.BIRTHDATE = new DateTime(Convert.ToInt32(splitDate1[2]), Util.MonthToNumber(splitDate1[1]), Convert.ToInt32(splitDate1[0]));
r.STARTING_DATE = new DateTime(Convert.ToInt32(splitDate2[2]), Util.MonthToNumber(splitDate2[1]), Convert.ToInt32(splitDate2[0]));
r.InsertRequest();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('อัพเดทข้อมูลเรียบร้อย')", true);
}
public int AddClass(ClassRequest request)
{
AuthenticateUserToken(request.UserToken);
return(MyClassService.AddClass(request.Class));
}
public void Post([FromBody] ClassRequest request)
{
}
public Task <Unit> Handle(ClassRequest classRequest, CancellationToken cancellationToken) => throw new NotImplementedException();
public async Task <IActionResult> AddClass(int semesterId, [FromBody] ClassRequest model)
{
return(await _semesterService.AddClass(semesterId, model));
}
public bool UpdateClass(ClassRequest request)
{
return(_classService.UpdateClass(AutoMapper.Mapper.Map <ClassModel>(request)));
}
public void EditClass(ClassRequest request)
{
AuthenticateUserToken(request.UserToken);
MyClassService.EditClass(request.Class);
}
public async Task <IActionResult> Create([FromServices] IClassService classService, ClassRequest request)
{
if (string.IsNullOrEmpty(request.Name))
{
throw new ArgumentNullException(nameof(request.Name));
}
if (request.SchoolId == null)
{
throw new ArgumentNullException(nameof(request.SchoolId));
}
return(Ok(await classService.Create(request)));
}
private void FRM_Request_Managment_Load(object sender, EventArgs e)
{
dgvReqMang.DataSource = ClassRequest.SP_REQUESTDISPLAY();
}
public async Task <IActionResult> AddStudent([FromBody] ClassRequest clsR)
{
return(Ok(await _classService.AddClassAsync(clsR)));
}
public IActionResult GetAllClasses(ClassRequest classRequest)
{
_mainResponse = _classService.GetAllClasses(classRequest);
_jsonString = Mapper.Convert <GetAllClasses>(_mainResponse);
return(new OkObjectResult(_jsonString));
}
