// Delete Category
public async Task <CosApiResponse> DeleteCatgory(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
/* delete */
var cateDB = _db.Categories.Where(x => x.Id == request.ID && x.Status == (byte)Constants.EStatus.Actived).FirstOrDefault();
if (cateDB != null)
{
cateDB.Status = (byte)Constants.EStatus.Deleted;
if (_db.SaveChanges() > 0)
{
response.Success = true;
}
else
{
response.Message = "Unable to delete category";
}
}
else
{
response.Message = " Unable to find category";
NSLog.Logger.Info("Response Delete Category", response);
}
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Delete Category", null, response, ex); }
finally { }
return(response);
}
public async static Task <T> AccessAPI <T>(string url, RequestModelBase requestModel)
where T : ReturnValueBase
{
var req = HttpWebRequest.Create(url);
if (req == null)
{
throw new ArgumentException("invalid url");
}
req.Method = "POST";
req.ContentType = "application/x-www-form-urlencoded;charset=utf-8";
req.Headers["UserAgent"] = "snake-ddnspod/0.1.0 ([email protected])";
using (var reqStream = await req.GetRequestStreamAsync())
{
var queryString = requestModel.ToQueryString();
var bytes = Encoding.UTF8.GetBytes(queryString);
await reqStream.WriteAsync(bytes, 0, bytes.Length);
}
var res = await req.GetResponseAsync();
using (var ResStream = res.GetResponseStream())
{
using (var sr = new StreamReader(ResStream))
{
var data = await sr.ReadToEndAsync();
return(await JsonConvert.DeserializeObjectAsync <T>(data));
}
}
}
// Delete Order
public async Task <CosApiResponse> DeleteOrder(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
/* delete */
var OrderDB = _db.Orders.Where(o => o.Id == request.ID && o.Status == (byte)Constants.EStatus.Actived).FirstOrDefault();
if (OrderDB != null)
{
OrderDB.Status = (byte)Constants.EStatus.Deleted;
/* Save change data */
if (_db.SaveChanges() > 0)
{
response.Success = true;
}
else
{
response.Message = "Unable to delete Order";
}
}
else
{
response.Message = "Unable to find Order";
}
NSLog.Logger.Info("Response Delete Order", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Delete Order", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
public async Task <T> Request <T>(RequestModelBase requestModel)
{
// combine base URL with the URL for the specific request
WebRequest request = WebRequest.Create(requestModel.ToUri(_baseUri));
// Get the response.
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
// Display the status.
Console.WriteLine(response.StatusDescription);
// Get the stream containing content returned by the server.
Stream dataStream = response.GetResponseStream();
// Open the stream using a StreamReader for easy access.
// StreamReader reader = new StreamReader(dataStream);
// Read the content.
//// string responseFromServer = reader.ReadToEnd();
// Display the content.
// Console.WriteLine(responseFromServer);
// Cleanup the streams and the response.
// reader.Close();
T result = await JsonSerializer.DeserializeAsync <T>(dataStream, new JsonSerializerOptions
{
PropertyNameCaseInsensitive = true
});
dataStream.Close();
response.Close();
return(result);
}
// Get List Role
public async Task <CosApiResponse> GetListRole(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetListRoleResponse result = new GetListRoleResponse();
/* get Role */
var query = _db.Roles.Where(o => o.Status == (byte)Constants.EStatus.Actived);
result.ListRole = query.Select(o => new RoleDTO()
{
Id = o.Id,
Name = o.Name,
RoleLevel = o.RoleLevel,
}).ToList();
/* response data */
response.Data = result;
NSLog.Logger.Info("Response Get List role", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Get List role", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
public async Task <T> AccessAPI <T>(string url, RequestModelBase requestModel)
where T : ReturnValueBase
{
var type = typeof(T);
return(await Task.Factory.StartNew <T>(() => Activator.CreateInstance <T>()));
}
// Get Detail Category
public async Task <CosApiResponse> GetDetailCategory(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetIDCategoryResponse result = new GetIDCategoryResponse();
var cateDB = _db.Categories.Where(x => x.Id == request.ID && x.Status == (byte)Constants.EStatus.Actived).FirstOrDefault();
if (cateDB != null)
{
var responseCate = new CategoryDTO()
{
Id = cateDB.Id,
Name = cateDB.Name,
ParentId = cateDB.ParentId,
};
result.Cate = responseCate;
response.Data = result;
}
else
{
response.Message = "Unable to find category";
NSLog.Logger.Info("Response Get Detail Category", response);
}
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Get Detail Category", null, response, ex); }
finally { }
return(response);
}
// Get List Order
public async Task <CosApiResponse> GetListOrder(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetListOrderResponse result = new GetListOrderResponse();
/* get oder */
var query = _db.Orders.Where(o => o.Status == (byte)Constants.EStatus.Actived);
result.ListOrder = query.Select(o => new OrderDTO()
{
Id = o.Id,
CustomerId = o.CustomerId,
OrderNo = o.OrderNo,
ReceiptNo = o.ReceiptNo,
TotalBill = o.TotalBill,
Discount = o.Discount,
}).ToList();
/* response data */
response.Data = result;
NSLog.Logger.Info("Response Get List Order", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Get List Order", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
public async Task <CosApiResponse> GetIDProduct(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetIDProductResponse result = new GetIDProductResponse();
/* get product */
var proDB = _db.Products.Where(o => o.Id == request.ID && o.Status == (byte)Constants.EStatus.Actived).FirstOrDefault();
if (proDB != null)
{
var responsePro = new ProductDTO()
{
ID = proDB.Id,
Name = proDB.Name,
Price = (float)proDB.Price,
};
result.Pro = responsePro;
response.Data = result;
}
else
{
response.Message = "Unable to find product";
}
NSLog.Logger.Info("ResponseGetIDProduct", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("ErrorGetIDProduct", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
public async Task <CosApiResponse> GetListProduct(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetListProductResponse result = new GetListProductResponse();
/* get product */
var query = _db.Products.Where(o => o.Status == (byte)Constants.EStatus.Actived);
result.ListProd = query.Select(o => new ProductDTO()
{
ID = o.Id,
Name = o.Name,
Price = (float)o.Price,
}).ToList();
/* response data */
response.Data = result;
NSLog.Logger.Info("ResponseGetListProduct", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("ErrorGetListProduct", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
public async Task <T> AccessAPI <T>(string serviceName, string methodName, RequestModelBase requestModel)
where T : ReturnValueBase
{
var url = BuildAPIUrl(serviceName, methodName);
return(await AccessAPI <T>(url, requestModel));
}
// Get Detail Role
public async Task <CosApiResponse> GetDetailRole(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetDetailRoleResponse result = new GetDetailRoleResponse();
/* get Role */
var RoleDB = _db.Roles.Where(o => o.Id == request.ID && o.Status == (byte)Constants.EStatus.Actived).FirstOrDefault();
if (RoleDB != null)
{
var responseRole = new RoleDTO()
{
Id = RoleDB.Id,
Name = RoleDB.Name,
RoleLevel = RoleDB.RoleLevel,
};
result.Role = responseRole;
response.Data = result;
}
else
{
response.Message = "Unable to find role";
}
NSLog.Logger.Info("Response Get Detail role", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Get Detail role", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
//Get List Customer
public async Task <CosApiResponse> GetListCustomer(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetListCustomerResponse result = new GetListCustomerResponse();
/* get Customer */
var query = _db.Customers.Where(o => true /* o.Status == Constants.EStatus.Actived*/);
result.ListCustomer = query.Select(o => new CustomersDTO()
{
Id = o.Id,
Name = o.Name,
Email = o.Email,
Country = o.Country,
Phone = o.Phone,
Active = o.Active,
City = o.City,
}).ToList();
/* response data */
response.Data = result;
NSLog.Logger.Info("Response Get List customer", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Get List customer", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
public async Task <ActionResult <ResponseModelBase> > GetListAsync([FromBody] RequestModelBase <TSerachConditionModel> model)
{
TQueryList query = Mapper.Map <TQueryList>(model.Model);
query.Context = Mapper.Map <RequestContextBase>(model.RequestContext);
return(await DoQueryListAsync <TQueryList, TDto, TViewModel>(query));
}
// Get List User
public async Task <CosApiResponse> GetListUser(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetListUserResponse result = new GetListUserResponse();
/* get User */
var query = _db.Users.Where(o => o.Status == (byte)Constants.EStatus.Actived);
result.ListUser = query.Select(o => new UserDTO()
{
Id = o.Id,
Name = o.Name,
Email = o.Email,
Password = o.Password,
Phone = o.Phone,
Active = o.Active,
RoleId = o.RoleID,
}).ToList();
/* response data */
response.Data = result;
NSLog.Logger.Info("Response Get List Users", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Get List Users", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
public override ResponseModel <TenantViewModel> GetAll(RequestModelBase <Tenant> requestModel)
{
var queryable = GetPagingQuery(_repository.GetAllAsTenant().Include(x => x.Edition), requestModel);
var entities = GetEntries(queryable);
var response = new ResponseModel <TenantViewModel>(entities, _repository.GetAllAsTenant().Count());
return(response);
}
public override ResponseModel <SubscriptionViewModel> GetAll(RequestModelBase <Subscription> requestModel)
{
var queryable = GetPagingQuery(Repository.GetAll().Include(x => x.Tenant), requestModel);
var entities = GetEntries(queryable);
var response = new ResponseModel <SubscriptionViewModel>(entities, Repository.GetAll().Count());
return(response);
}
//
// Summary:
// Maps received data from client to service command.
// Calls action perform the command.
protected void DoCommandAsyncVoid <TModel, TCommand>(RequestModelBase <TModel> request)
where TCommand : ICommandBase
{
//Map data from Request Object to Command Object
TCommand command = Mapper.Map <TCommand>(request);
// Call Command Handler
DoCommandAsyncVoid(command);
}
//
// Summary:
// Maps received data from client to service command.
// Calls action perform the command.
// Return:
// Tpd.Api.Core.Interface.ResponseModelBase formated data to response to client
protected ActionResult <ResponseModelBase> DoCommand <TModel, TCommand>(RequestModelBase <TModel> request)
where TCommand : ICommandBase
{
//Map data from Request Object to Command Object
TCommand command = Mapper.Map <TCommand>(request);
// Call Command Handler
return(DoCommand(command));
}
public virtual ResponseModel <TVm> Search(PagingDataType status, RequestModelBase <TEntity> requestModel)
{
var count = Repository.GetAll().Where(requestModel.GetExpression()).Count();
var response = GetAll(requestModel);
response.Count = count;
return(response);
}
///=================
//PAGING BLOCK Start
//==================
#region Paging List Query Block
public virtual ResponseModel <TVm> GetAll(RequestModelBase <TEntity> requestModel)
{
var queryable = GetPagingQuery(Repository.GetAll(), requestModel);
var entities = GetEntries(queryable);
var response = new ResponseModel <TVm>(entities, Repository.GetAll().Count());
//
return(response);
}
public ActionResult <ResponseModelBase> GetLanguageByModule([FromBody] RequestModelBase <GetLanguageByModuleModel> model)
{
var query = new GetLanguageByModuleQuery()
{
IsPaged = false,
Application = model.Model.Application,
Module = model.Model.Module,
Language = model.RequestContext.Language
};
return(DoQueryList <GetLanguageByModuleQuery, DtoLanguageByModule>(query));
}
// Get Detail Customer
public async Task <CosApiResponse> GetDetailCustomer(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetDetailCustomerResponse result = new GetDetailCustomerResponse();
/* get Customer */
var customerDB = _db.Customers.Where(o => o.Id == request.ID && o.Status == (byte)Constants.EStatus.Actived).FirstOrDefault();
if (customerDB != null)
{
var responseUser = new CustomersDTO()
{
Id = customerDB.Id,
Name = customerDB.Name,
Email = customerDB.Email,
Phone = customerDB.Phone,
Active = customerDB.Active,
City = customerDB.City,
Country = customerDB.Country,
};
result.Customer = responseUser;
response.Data = result;
}
else
{
response.Message = "Unable to find customer";
}
NSLog.Logger.Info("Response Get Detail customer", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Get Detail customer", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
// Get Detail Order
public async Task <CosApiResponse> GetDetailOrder(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetDetailOrderResponse result = new GetDetailOrderResponse();
/* get order */
var OrderDB = _db.Orders.Where(o => o.Id == request.ID && o.Status == (byte)Constants.EStatus.Actived).FirstOrDefault();
if (OrderDB != null)
{
var responseOrder = new OrderDTO()
{
Id = OrderDB.Id,
CustomerId = OrderDB.CustomerId,
ReceiptNo = OrderDB.ReceiptNo,
OrderNo = OrderDB.OrderNo,
TotalBill = OrderDB.TotalBill,
Discount = OrderDB.Discount,
};
result.Order = responseOrder;
response.Data = result;
}
else
{
response.Message = "Unable to find Order";
}
NSLog.Logger.Info("Response Get Detail Order", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Get Detail Order", null, response, ex); }
finally { /*_db.Refresh();*/ }
return(response);
}
// Get List Category
public async Task <CosApiResponse> GetListCategory(RequestModelBase request)
{
var response = new CosApiResponse();
try
{
using (var _db = new CosContext())
{
GetListCategoryResponse result = new GetListCategoryResponse();
var query = _db.Categories.Where(x => x.Status == (byte)Constants.EStatus.Actived);
result.ListCate = query.Select(x => new CategoryDTO()
{
Id = x.Id,
Name = x.Name,
ParentId = x.ParentId,
}).ToList();
response.Data = result;
NSLog.Logger.Info("Response Get List Category", response);
}
}
catch (Exception ex) { NSLog.Logger.Error("Error Get List Category", null, response, ex); }
finally { }
return(response);
}
public async Task <CosApiResponse> DeleteRole(RequestModelBase request)
{
NSLog.Logger.Info("DeleteRole", request);
return(await CosBusRole.Instance.DeleteRole(request));
}
public async Task <CosApiResponse> GetIDRole(RequestModelBase request)
{
NSLog.Logger.Info("GetIDRole", request);
return(await CosBusRole.Instance.GetDetailRole(request));
}
public IHttpActionResult Page4Venue(string query)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
RequestModelBase <ApplyTryoutCurriculumRequest> oData = JsonConvert.DeserializeObject <RequestModelBase <ApplyTryoutCurriculumRequest> >(query);
if (oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
criteria.Condition = "1=1";
if (!string.IsNullOrWhiteSpace(oData.SearchCondition.StudentMobile))
{
criteria.Condition += string.Format(" and s.Mobile = '{0}'", oData.SearchCondition.StudentMobile);
}
if (!string.IsNullOrWhiteSpace(oData.SearchCondition.StudentParentMobile))
{
criteria.Condition += string.Format(" and s.ParentMobile = '{0}'", oData.SearchCondition.StudentParentMobile);
}
if (!string.IsNullOrWhiteSpace(oData.SearchCondition.CoachMobile))
{
criteria.Condition += string.Format(" and c.Mobile = '{0}'", oData.SearchCondition.CoachMobile);
}
if (oData.SearchCondition.StudentID > 0)
{
criteria.Condition += string.Format(" and a.StudentID = {0}", oData.SearchCondition.StudentID);
}
if (oData.SearchCondition.coachID > 0)
{
criteria.Condition += string.Format(" and a.CoachID = {0}", oData.SearchCondition.coachID);
}
if (oData.SearchCondition.TryoutState > -1)
{
criteria.Condition += string.Format(" and a.TryoutState = {0}", oData.SearchCondition.TryoutState);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.StartAddTime))
{
criteria.Condition += string.Format(" and a.AddTime >= '{0}'", oData.SearchCondition.StartAddTime);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.EndAddTime))
{
criteria.Condition += string.Format(" and a.AddTime < '{0}'", Convert.ToDateTime(oData.SearchCondition.EndAddTime).AddDays(1));
}
criteria.CurrentPage = oData.PageIndex + 1;
criteria.Fields = "[id],[TSMID],[AddTime],[TryoutState],[AduitTime],[PayState],[PayMoney],[PayTime],[PKID],a.[StudentID],s.FullName as StudentFullName,s.ParentFullName as StudentParentFullName,s.Mobile as StudentMobile,s.ParentMobile as StudentParentMobile,[TryoutMoney],a.[coachID],c.FullName as CoachFullName,c.Mobile as CoachMobile";
criteria.PageSize = oData.PageSize;
criteria.TableName = "[dbo].[ApplyTryoutCurriculum] as a join Student as s on a.studentid=s.StudentID join Coach as c on a.coachID=c.CoachID";
criteria.PrimaryKey = "a.id";
var r = DapperHelper.GetPageData <Models.ResponseModel.ApplyTryoutCurriculumResponse>(criteria);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <Models.ResponseModel.ApplyTryoutCurriculumResponse>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
}));
}
catch (Exception ex)
{
logs.Error("试课列表查询失败", ex);
return(BadRequest());
}
}
public async Task <CosApiResponse> GetListUser(RequestModelBase request)
{
NSLog.Logger.Info("GetListUser", request);
return(await CosBusUser.Instance.GetListUser(request));
}
public async Task <CosApiResponse> GetDetailCategory(RequestModelBase request)
{
NSLog.Logger.Info("Get Detail Category", request);
return(await CosBusCategory.Instance.GetDetailCategory(request));
}
