/// <summary>
/// Delete all data of student
/// </summary>
/// <param name="IdStudent"></param>
/// <returns></returns>
public DTResponse DeleteStudent(int IdStudent)
{
DTResponse Resp = new DTResponse();
try
{
var student = _ObjStudentRepository.GetAllBy(i => i.Id == IdStudent).FirstOrDefault();
if (student != null)
{
_ObjStudentRepository.Delete(student);
Resp.response = true;
Resp.message = "Success";
}
else
{
Resp.response = false;
Resp.message = "Not found";
}
}
catch (Exception ex)
{
Resp.response = false;
Resp.message = ex.Message;
}
return(Resp);
}
public ActionResult <DTResponse> CreateVisit(DTVisit objVisit)
{
DTResponse Resp = new DTResponse();
DTVisitValidator objVisitValidator = new DTVisitValidator();
ValidationResult result = new ValidationResult();
//Validate fields required
result = objVisitValidator.Validate(objVisit);
if (result.IsValid)
{
Resp = _ObjVisit.CreateVisit(objVisit);
if (Resp.response)
{
_ObjClient.ModifyCreditandVisits(objVisit.IdClient);
}
}
else
{
Resp.response = false;
foreach (var failure in result.Errors)
{
Resp.message += "Error was: " + failure.ErrorMessage + "-> ";
}
}
return(Resp);
}
/// <summary>
/// Modify data of Student
/// </summary>
/// <param name="objStudent"></param>
/// <returns></returns>
public DTResponse ModifyStudent(DTStudent objStudent)
{
DTResponse Resp = new DTResponse();
try
{
var student = _ObjStudentRepository.GetAllBy(i => i.Id == objStudent.Id).FirstOrDefault();
if (student != null)
{
student = _Objmapper.Map <Student>(objStudent);
_ObjStudentRepository.Update(student);
Resp.response = true;
Resp.message = "Success";
}
else
{
Resp.response = false;
Resp.message = "Not found";
}
}
catch (Exception ex)
{
Resp.response = false;
Resp.message = ex.Message;
}
return(Resp);
}
/// <summary>
/// Modify all data of client
/// </summary>
/// <param name="objClient"></param>
/// <returns></returns>
public DTResponse ModifyClient(DTClient objClient)
{
DTResponse Resp = new DTResponse();
try
{
Client Client = _ObjClientRepository.GetAllBy(i => i.IdClient == objClient.IdClient).FirstOrDefault();
//Calculate available credit
if (Client != null)
{
int diferenceCredit = objClient.CreditLimit - Client.CreditLimit;
objClient.AvailableCredit = objClient.AvailableCredit + diferenceCredit;
}
objClient.Nit = Base64Encode(objClient.Nit);
//Client ClientBD = new Client();
Client = _Objmapper.Map <Client>(objClient);
_ObjClientRepository.Update(Client);
Resp.response = true;
Resp.message = "Success";
}
catch (Exception ex)
{
Resp.response = false;
Resp.message = ex.Message;
}
return(Resp);
}
public static DTResponse GetUsers(DTRequest request)
{
var context = new AdminDbContext();
var response = new DTResponse()
{
draw = request.draw
};
var users = context.Users;
var data = users.AsEnumerable();
if (request.order != null && request.order.Any())
{
var asc = request.order[0].dir == "asc";
switch (request.order[0].column)
{
case 0:
{
data = asc ? data.OrderBy(u => u.Id) : data.OrderByDescending(u => u.Id);
break;
}
case 1:
{
data = asc ? data.OrderBy(u => u.Email) : data.OrderByDescending(u => u.Email);
break;
}
case 2:
{
data = asc ? data.OrderBy(u => u.RegisterDate) : data.OrderByDescending(u => u.RegisterDate);
break;
}
case 3:
{
data = asc ? data.OrderBy(u => u.Active) : data.OrderByDescending(u => u.Active);
break;
}
default:
{
data = data.OrderBy(u => u.Id);
break;
}
}
}
response.recordsFiltered = data.Count();
data = data.Skip(request.start).Take(request.length);
var responseData = data.Select(u => new UserModel {
Id = u.Id, Email = u.Email, Active = u.Active, RegisterDate = u.RegisterDate
});
response.data = responseData;
response.recordsFiltered = users.Count();
response.recordsTotal = context.Users.Count();
return(response);
}
public static DTResponse GetRelationTypes(DTRequest request)
{
var context = new AdminDbContext();
var response = new DTResponse()
{
draw = request.draw
};
var relationTypes = context.RelationTypes;
var data = relationTypes.AsEnumerable();
if (request.order != null && request.order.Any())
{
var asc = request.order[0].dir == "asc";
switch (request.order[0].column)
{
case 0:
{
data = asc ? data.OrderBy(u => u.Id) : data.OrderByDescending(u => u.Id);
break;
}
case 1:
{
data = asc ? data.OrderBy(u => u.Code) : data.OrderByDescending(u => u.Code);
break;
}
case 2:
{
data = asc ? data.OrderBy(u => u.Name) : data.OrderByDescending(u => u.Name);
break;
}
default:
{
data = data.OrderBy(u => u.Id);
break;
}
}
}
response.recordsFiltered = data.Count();
data = data.Skip(request.start).Take(request.length);
var responseData = data.Select(u => new RelationTypeDisplayModel {
Id = u.Id, Code = u.Code, Name = u.Name, Relations = u.Relations.Count()
});
response.data = responseData;
response.recordsTotal = context.RelationTypes.Count();
return(response);
}
public ActionResult <DTResponse> DeleteClient(int IdClient)
{
DTResponse Resp = new DTResponse();
//DeleteVisits
bool resp = _ObjVisit.DeleteVitis(IdClient);
//DeleteClient
if (resp)
{
Resp = _ObjClient.DeleteClient(IdClient);
}
return(Resp);
}
/// <summary>
/// Insert new students
/// </summary>
/// <param name="objStudent"></param>
/// <returns>DTResponse</returns>
public DTResponse CreateStudent(DTStudent objStudent)
{
DTResponse Resp = new DTResponse();
try
{
var StudentBD = _Objmapper.Map <Student>(objStudent);
_ObjStudentRepository.Create(StudentBD);
Resp.response = true;
Resp.message = "Success";
}
catch (Exception ex)
{
Resp.message = ex.Message;
}
return(Resp);
}
public JsonResult QuarterlyCommissionList(DTParameterModel model, int year)
{
var repo = new SalesRepository();
var commissionList = repo.GetQuarterlyCommission(year);
var pdto = new DTResponse
{
recordsTotal = commissionList.Count(),
recordsFiltered = commissionList.Count(),
data = commissionList,
draw = model.Draw,
error = ""
};
return(new JsonResult {
Data = pdto, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult SalesList(DTParameterModel model, DateTime?startDate, DateTime?endDate)
{
var repo = new SalesRepository();
var sales = repo.GetSales(startDate, endDate);
var pdto = new DTResponse
{
recordsTotal = sales.Count(),
recordsFiltered = sales.Count(),
data = sales,
draw = model.Draw,
error = ""
};
return(new JsonResult {
Data = pdto, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult ProductList(DTParameterModel model)
{
var repo = new ProductRepository();
var products = repo.GetProducts();
var pdto = new DTResponse
{
recordsTotal = products.Count(),
recordsFiltered = products.Count(),
data = products,
draw = model.Draw,
error = ""
};
return(new JsonResult {
Data = pdto, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult CustomerList(DTParameterModel model)
{
var repo = new CustomerRepository();
var customers = repo.GetCustomers();
var pdto = new DTResponse
{
recordsTotal = customers.Count(),
recordsFiltered = customers.Count(),
data = customers,
draw = model.Draw,
error = ""
};
return(new JsonResult {
Data = pdto, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
/// <summary>
/// Insert new visits
/// </summary>
/// <param name="objvisit"></param>
/// <returns>DTResponse</returns>
public DTResponse CreateVisit(DTVisit objvisit)
{
DTResponse Resp = new DTResponse();
try
{
Visit VisitBD = new Visit();
VisitBD = _Objmapper.Map <Visit>(objvisit);
_ObjVisitRepository.Create(VisitBD);
Resp.response = true;
Resp.message = "Success";
}
catch (Exception ex)
{
Resp.message = ex.Message;
}
return(Resp);
}
public JsonResult SalesPersonList()
{
var repo = new SalesPersonRepository();
var salesPersonList = repo.GetSalesPersons();
var pdto = new DTResponse
{
recordsTotal = salesPersonList.Count(),
recordsFiltered = salesPersonList.Count(),
data = salesPersonList,
draw = 0,
error = ""
};
return(new JsonResult {
Data = pdto, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
/// <summary>
/// Insert new clients
/// </summary>
/// <param name="objClient"></param>
/// <returns>DTResponse</returns>
public DTResponse CreateClient(DTClient objClient)
{
DTResponse Resp = new DTResponse();
try
{
objClient.Nit = Base64Encode(objClient.Nit);
Client ClientBD = new Client();
ClientBD = _Objmapper.Map <Client>(objClient);
_ObjClientRepository.Create(ClientBD);
Resp.response = true;
Resp.message = "Success";
}
catch (Exception ex)
{
Resp.message = ex.Message;
}
return(Resp);
}
///Modify avilable credit and number visits
public DTResponse ModifyCreditandVisits(int IdClient)
{
DTResponse Resp = new DTResponse();
try
{
Client ObjClient = _ObjClientRepository.GetAllBy(i => i.IdClient == IdClient).FirstOrDefault();
if (ObjClient != null)
{
ObjClient.AvailableCredit = ObjClient.AvailableCredit - 1;
_ObjClientRepository.Update(ObjClient);
}
Resp.response = true;
Resp.message = "Success";
}
catch (Exception ex)
{
Resp.response = false;
Resp.message = ex.Message;
}
return(Resp);
}
/// <summary>
/// Delete all data of a client
/// </summary>
/// <param name="objClient"></param>
/// <returns></returns>
public DTResponse DeleteClient(int IdClient)
{
DTResponse Resp = new DTResponse();
try
{
Client Query = _ObjClientRepository.GetAllBy(i => i.IdClient == IdClient).FirstOrDefault();
if (Query != null)
{
_ObjClientRepository.Delete(Query);
}
Resp.response = true;
Resp.message = "Success";
}
catch (Exception ex)
{
Resp.response = false;
Resp.message = ex.Message;
}
return(Resp);
}
public ActionResult <DTResponse> CreateStudent(DTStudent objStudent)
{
DTResponse Resp = new DTResponse();
DTStudentValidator objStudentValidator = new DTStudentValidator();
ValidationResult result = new ValidationResult();
//Validate fields required
result = objStudentValidator.Validate(objStudent);
if (result.IsValid)
{
Resp = _ObjStudent.CreateStudent(objStudent);
}
else
{
Resp.response = false;
foreach (var failure in result.Errors)
{
Resp.message += "Error was: " + failure.ErrorMessage + "-> ";
}
}
return(Resp);
}
