public TranferResponse<Dform> GetForm(Guid formId)
{
var response = new TranferResponse<Dform>();
try
{
var form = _context.Forms.FirstOrDefault(s => s.Id == formId);
Dform f = new Dform();
f.Name = form.Name;
f.Id = form.Id;
foreach (var respondentType in form.RespondentTypes)
{
DformRespondentType rt= new DformRespondentType();
rt.Code = respondentType.Code;
rt.Name = respondentType.Name;
rt.Id = respondentType.Id;
f.RespondentTypes.Add(rt);
}
foreach (var item in form.FormItems)
{
var i = new DformItem();
i.Label = item.Label;
i.IsRequired = item.IsRequired;
i.Id = item.Id;
i.FormItemType = item.FormItemType;
i.Order = item.Order;
i.ValidationRegex = item.ValidationRegex;
i.ValidationText = item.ValidationText;
foreach (var answers in item.FormItemAnswers)
{
var a = new DformItemAnswer();
a.Id = answers.Id;
a.Text = answers.Text;
a.Value = answers.Value;
i.FormItemAnswer.Add(a);
}
foreach (var respondentType in item.FormItemRespondentTypes)
{
var a = new DformItemRespondentType();
a.Id = respondentType.Id;
a.FormItemId = respondentType.FormItemId;
a.RespondentTypeId = respondentType.FormRespondentTypeId;
i.FormItemRespondentTypes.Add(a);
}
f.FormItems.Add(i);
}
response.Data = new List<Dform> { f };
response.Status = true;
}
catch(Exception ex)
{
response.Status = false;
response.Info = ex.Message;
}
return response;
}
public HttpResponseMessage Login(string username, string password)
{
HttpStatusCode returnCode = HttpStatusCode.OK;
var response = new TranferResponse<UserDTO>();
try
{
response = _userService.Login(username, password);
response.Status = true;
}
catch (Exception ex)
{
response.Info = ex.Message;
response.Status = false;
returnCode = HttpStatusCode.ServiceUnavailable;
}
return Request.CreateResponse(returnCode, response);
}
public TranferResponse<FormItemDTO> QueryItem(QueryBase query)
{
var response = new TranferResponse<FormItemDTO>();
try
{
var data = _formRepository.QueryFormItem(query);
var result = data.Result.Select(Map).ToList();
response.Data.AddRange(result);
response.Status = true;
response.RecordCount = data.Count;
}
catch (Exception ex)
{
response.Info = ex.Message;
response.Status = false;
}
return response;
}
public TranferResponse<ReportGroupDTO> Query(QueryBase query)
{
var response = new TranferResponse<ReportGroupDTO>();
try
{
var data = _reportGroupRepository.Query(query);
var result = data.Result.OfType<ReportGroup>().Select(Map).ToList();
response.Data.AddRange(result);
response.Status = true;
response.RecordCount = data.Count;
}
catch (Exception ex)
{
response.Info = ex.Message;
response.Status = false;
}
return response;
}
public TranferResponse<CustomSelectListItem> GetSaleProduct(int? skip, int? take, string search = "")
{
var result = new TranferResponse<CustomSelectListItem>();
IQueryable<tblProduct> query = _ctx.tblProduct.Where(s => s.DomainTypeId == (int)DomainProductType.Sale && s.IM_Status==(int)EntityStatus.Active).AsQueryable();
if (!string.IsNullOrWhiteSpace(search))
{
query = query.Where(s => s.Description.Contains(search) ||
s.ProductCode.Contains(search)
);
}
query = query.OrderBy(s => s.Description);
result.RecordCount = query.Count();
if (skip.HasValue & take.HasValue)
{
query = query.Skip(skip.Value).Take(take.Value);
}
result.Data = query.ToList().Select(s => new CustomSelectListItem { Text = s.Description, Value = s.id.ToString() }).ToList();
return result;
}
public TranferResponse<CustomSelectListItem> GetDistributors(int? skip, int? take, string search = "")
{
var result = new TranferResponse<CustomSelectListItem>();
IQueryable<tblCostCentre> query = _ctx.tblCostCentre.Where(s => s.CostCentreType == (int)CostCentreType.Distributor).AsQueryable();
if (!string.IsNullOrWhiteSpace(search))
{
query = query.Where(s => s.Name.Contains(search) ||
s.Cost_Centre_Code.Contains(search)
);
}
query = query.OrderBy(s => s.Name);
result.RecordCount = query.Count();
if (skip.HasValue & take.HasValue)
{
query = query.Skip(skip.Value).Take(take.Value);
}
result.Data = query.ToList().Select(s => new CustomSelectListItem { Text = s.Name, Value = s.Id.ToString() }).ToList();
return result;
}
public TranferResponse<UserDTO> Login(string username, string password)
{
var response = new TranferResponse<UserDTO>();
try
{
var user = _userRepository.MobileLogin(username, password);
if (user != null)
{
response.Data.Add(Map(user));
response.Status = true;
response.Info = "Success";
}
}
catch (Exception ex)
{
response.Info = ex.Message;
response.Status = false;
}
return response;
}
public TranferResponse<RouteDTO> GetRoute(Guid accountid)
{
TranferResponse<RouteDTO> response = new TranferResponse<RouteDTO>();
try
{
var data = _routeRepository.Query(new QueryMasterData { AccountId = accountid }).Result.OfType<Route>().Select(Map).ToList();
response.Data.AddRange(data);
response.Status = true;
}
catch (Exception ex)
{
response.Info = ex.Message;
response.Status = false;
}
return response;
}
public TranferResponse<CountryDTO> GetCountry()
{
TranferResponse<CountryDTO> response = new TranferResponse<CountryDTO>();
try
{
var data = _countryRepository.Query(new QueryMasterData()).Result.OfType<Country>().Select(Map).ToList();
response.Data.AddRange(data);
response.Status = true;
}
catch (Exception ex)
{
response.Info = ex.Message;
response.Status = false;
response.Info = "Success";
}
return response;
}
public TranferResponse<CategoryDTO> GetCategory(QueryMasterData query)
{
TranferResponse<CategoryDTO> response = new TranferResponse<CategoryDTO>();
try
{
var data = _categoryRepository.Query(query);
var result=data.Result.OfType<Category>().Select(Map).ToList();
response.Data.AddRange(result);
response.Status = true;
response.RecordCount = data.Count;
}
catch (Exception ex)
{
response.Info = ex.Message;
response.Status = false;
}
return response;
}
public TranferResponse<AccountDTO> GetAccount(Guid accountid)
{
TranferResponse<AccountDTO> response = new TranferResponse<AccountDTO>();
try
{
var data = _accountRepository.GetById(accountid);//.Query(new QueryMasterData()).Result.OfType<User>().Select(MapUserToUserDto).ToList();
if(data==null)
{
response.Info = "invalid account id";
response.Status = false;
return response;
}
response.Data.Add(Map(data));
response.Status = true;
}
catch (Exception ex)
{
response.Info = ex.Message;
response.Status = false;
}
return response;
}
public TranferResponse<FormRespondentTypeDTO> GetFormRespodent(Guid formId)
{
var response = new TranferResponse<FormRespondentTypeDTO>();
try
{
response = _formService.QueryRespondentType(new QueryRespondentType {FormId = formId});
}
catch (Exception ex)
{
response.Status = false;
response.Info = ex.Message;
}
return response;
}
//
// GET: /Form/
public TranferResponse<IDDTO> GetFormIds(Guid clientId)
{
var response = new TranferResponse<IDDTO>();
try
{
response.Data =_context.Forms.Where(s => s.ClientId == clientId).Select(s => new IDDTO {Id = s.Id}).ToList();
response.Status = true;
}
catch (Exception ex)
{
response.Status = false;
response.Info = ex.Message;
}
return response;
}
