public void CallServiceBaseMethod(RequestItem Item)
{
ResponseItem re = new ResponseItem(Item);
re.RequestItem.RequestLog = re.RequestItem.RequestLog + "srv_start: " + DateTime.Now.ToString() + ",";
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
HelperClasses.Serializer srl = new HelperClasses.Serializer();
try
{
DateTime dFrom = DateTime.Now.AddMonths(-10).Date;
DateTime dTo = DateTime.Now.AddMonths(2).Date;
var periodsFrom = (from row in srvcont.DataContext.tbl_trDate.Where(w => w.Date >= dFrom && w.Date <= dTo)
select row.PeriodStarting).Distinct().ToList();
var periodsFromTo = from period in periodsFrom
select new
{
PeriodFromTo = period.Value.ToString("yyyy-MM-dd") + " - " + (period.Value.Day == 1 ? period.Value.AddDays(14).ToString("yyyy-MM-dd") :
(new DateTime(period.Value.AddMonths(1).Year, period.Value.AddMonths(1).Month, 1)).AddDays(-1).ToString("yyyy-MM-dd"))
};
re.ResponseBody = srl.NTSoftJsonSerialize(periodsFromTo.ToArray());
re.RequestCompleted = true;
}
catch (Exception ex)
{
//re.ResponseBody = ex.ToString();
re.RequestCompleted = false;
}
re.RequestItem.RequestLog = re.RequestItem.RequestLog + "srv_finish: " + DateTime.Now.ToString() + ",";
}
/// <summary>
/// Called when [exception].
/// </summary>
/// <param name="context">The context.</param>
public override void OnException(HttpActionExecutedContext context)
{
var matched = false;
var resultCode = ResultCodeEnum.Undefined;
var errorDescription = string.Empty;
if (context.Exception is UnAuthorizedException)
{
context.Response = new HttpResponseMessage(HttpStatusCode.Unauthorized);
resultCode = ResultCodeEnum.NotAuthorized;
errorDescription = "Not authorized to access resource";
matched = true;
}
if (context.Exception is BadRequestException)
{
context.Response = new HttpResponseMessage(HttpStatusCode.BadRequest);
resultCode = ResultCodeEnum.BadRequest;
errorDescription = "Bad Request";
matched = true;
}
if (context.Exception is NotFoundException)
{
context.Response = new HttpResponseMessage(HttpStatusCode.NotFound);
resultCode = ResultCodeEnum.NotFound;
errorDescription = "Not found";
matched = true;
}
if (context.Exception is MethodNotSupported)
{
context.Response = new HttpResponseMessage(HttpStatusCode.MethodNotAllowed);
resultCode = ResultCodeEnum.MethodNotSupported;
errorDescription = "Method not supported";
matched = true;
}
if (!matched)
{
context.Response = new HttpResponseMessage(HttpStatusCode.InternalServerError);
resultCode = ResultCodeEnum.GeneralFailure;
errorDescription = "Internal server exception";
}
var response = new ResponseItem<bool>(resultCode)
{
ResultDescription = errorDescription
};
var json = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(response);
context.Response.Content = new StringContent(json);
}
/// <summary>
/// Fetch a List of <see cref="ResponseItem"/> for display/processing.
/// </summary>
/// <returns>a List of <see cref="ResponseItem"/>.</returns>
public static List<ResponseItem> GetResponses()
{
List<ResponseItem> responseList = new List<ResponseItem>();
ResponseItem response = new ResponseItem();
for (int questionIndex = 0; questionIndex < questionData.GetLength(0); questionIndex++)
{
for (int responseIndex = 0; responseIndex < 4; responseIndex++)
{
response.QuestionNumber = (questionIndex + 1).ToString("D2");
response.ResponseNumber = (responseIndex + 1).ToString();
response.ResponseID = response.QuestionNumber + response.ResponseNumber; ;
response.ResponseText = questionData[questionIndex, responseIndex];
response.MostScore = questionData[questionIndex, 4].Substring(responseIndex, 1);
response.LeastScore = questionData[questionIndex, 5].Substring(responseIndex, 1);
responseList.Add(response);
}
}
return responseList;
}
void myService_TRS_GetLastFilledDayByUserCompleted(object sender, TRS_GetLastFilledDayByUserCompletedEventArgs e)
{
ResponseItem response = new ResponseItem();
List<TRDate> myDate = new List<TRDate>();
if (e.Result != null)
{
response = e.Result;
}
try
{
if (!string.IsNullOrEmpty(response.ResponseBody))
{
myDate = new JavaScriptSerializer().Deserialize<List<TRDate>>(response.ResponseBody);
}
if (myDate.Count > 0)
{
if (myDate[0].TRDateTime != DateTime.Now.Date)
{
// actualMessage = new frmMain();
Controls.frmMessage actualMessage = new Controls.frmMessage();
actualMessage.SetMessageLabel(myDate[0].TRDateTime.ToShortDateString());
actualMessage.Show();
}
}
}
catch (Exception)
{
throw;
}
}
public static string SignerUri(this ResponseItem responseItem)
{
return($"https://vk.com/id{responseItem.SignerId}");
}
public PRO_tblLevel1DRO()
{
ResponseItem = new ResponseItem();
}
public PRO_tblProvinceDRO()
{
ResponseItem = new ResponseItem();
}
public static string PostUri(this ResponseItem responseItem)
{
return($"https://vk.com/wall{responseItem.SourceId}_{responseItem.PostId}");
}
public void DealLocksController_GetLocks_Returns_OKResponseCode(int dealNumber, bool isLocked)
{
#region Arrange
Mock <IEntityLockRepository> dealLockRepository = new Mock <IEntityLockRepository>();
SetupUserIdentity();
SetupDealLockRepository(dealLockRepository, dealNumber, userIdentity.UserId, isLocked);
string url = $"{AppSettings.BASEURL}{ RouteHelper.DealsRoutePrefix }/{dealNumber}/locks";
//string url = $"{AppSettings.BASEURL}{RouteHelper.DealsRoutePrefix}{RouteHelper.DealLocksPrefix}";
var httpRequest = new HttpRequestMessage(new HttpMethod(AppSettings.HTTPGET), url);
DealLocksController dealLocksController = CreateDealLocksController(httpRequest, dealLockRepository.Object);
#endregion
#region Act
var response = dealLocksController.GetLocks(dealNumber);
var contentResult = response as NegotiatedContentResult <ResponseItem <EntityLock> >;
#endregion
#region Assert
#region Expected Data
var expectedDealLock = new EntityLock()
{
entityId = dealNumber,
entityTypeName = EntityType.Deals.ToString(),
lockedByDisplayName = "John Doe",
lockedTimestamp = DateTime.MinValue
};
string expectedURL = ($"/{ RouteHelper.DealsRoutePrefix }/{dealNumber }/locks");
var expectedMessages = new List <Message>();
Message expectedMessage = new Warning("entityID", $"{ expectedDealLock.lockedByDisplayName} has locked this deal for edit");
expectedMessages.Add(expectedMessage);
IList <Link> links = null;
ResponseItem <EntityLock> expectedContent = new ResponseItem <EntityLock>(expectedURL, expectedDealLock, links, expectedMessages);
#endregion
Assertions.AssertOkResponse(contentResult);
var actualDealLock = contentResult.Content.data;
if (isLocked)
{
Assertions.AreEqualByJson(expectedContent, contentResult.Content);
}
else
{
Assert.IsNull(actualDealLock);
Assert.IsNull(contentResult.Content.messages);
Assert.IsNull(links);
}
#endregion
}
public SYS_tblImportFileConfigDRO()
{
ResponseItem = new ResponseItem();
}
public PSIntranet.Service.ResponseItem Test_TRS_Update_Validation(PSIntranet.Service.RequestItem Item)
{
PSIntranet.Service.ResponseItem response = new ResponseItem(Item);
//var entity_in = srl.NTSoftJsonDeserialize<Entities.EntityViews.tblTimeReport_Transaction_Input>(Item.reqp_jsonarr);
//ValidationSettings settings = new ValidationSettings();
//settings.AddRule(TR_SumbitValidation.EnablesDataEntryOnSelectedDay);
//settings.AddRule(TR_SumbitValidation.DayIsNotWeekend);
//Validator validator = new Validator();
////ha bármelyik validálási szabály nem teljesül
//if (!validator.Validate(Item, settings, srvcont))
//{
// response.ResponseType = ResponseType.Message;
// response.ResponseHeader = srl.NTSoftJsonSerialize("Update failed!");
// response.ResponseBody = srl.NTSoftJsonSerialize(validator.ValidationMessage);
// response.RequestCompleted = false;
//}
return response;
}
public SYS_tblReportCaptionDRO()
{
ResponseItem = new ResponseItem();
}
public PRO_tblStoreDRO()
{
ResponseItem = new ResponseItem();
}
public void TRS_GetLastFilledDayByUser(RequestItem Item)
{
ResponseItem response = new ResponseItem();
myService.TRS_GetLastFilledDayByUserCompleted += new TRS_GetLastFilledDayByUserCompletedEventHandler(myService_TRS_GetLastFilledDayByUserCompleted);
myService.TRS_GetLastFilledDayByUserAsync(Item);
}
private void handleSingleRequest(HttpRequest servletRequest,
HttpResponse servletResponse, ISecurityToken token, BeanConverter converter)
{
RestfulRequestItem requestItem = new RestfulRequestItem(servletRequest, token, converter);
var asyncResult = HandleRequestItem(requestItem);
// handle just the one case where we can't find a handler
if (asyncResult == null)
{
sendError(servletResponse, new ResponseItem((int)HttpStatusCode.InternalServerError,
"The service " + requestItem.getService() + " is not implemented"));
return;
}
ResponseItem responseItem = getResponseItem(asyncResult);
servletResponse.ContentType = converter.GetContentType();
if (responseItem.getErrorCode() >= 200 && responseItem.getErrorCode() < 400)
{
Object resp = responseItem.getResponse();
// put single object responses into restfulcollection
if (!(resp is DataCollection) && !(resp is IRestfulCollection))
{
switch (requestItem.getService())
{
case IHandlerDispatcher.ACTIVITY_ROUTE:
if (resp is Activity)
{
resp = new RestfulCollection <Activity>((Activity)resp);
}
break;
case IHandlerDispatcher.PEOPLE_ROUTE:
if (resp is Person)
{
resp = new RestfulCollection <Person>((Person)resp);
}
break;
case IHandlerDispatcher.APPDATA_ROUTE:
if (requestItem.getOperation() != "POST")
{
resp = new DataCollection(new Dictionary <string, Dictionary <string, string> > {
{ "entry", (Dictionary <string, string>)resp }
});
}
break;
default:
resp = new Dictionary <string, object> {
{ "entry", resp }
};
break;
}
}
servletResponse.Output.Write(converter.ConvertToString(resp, requestItem));
}
else
{
sendError(servletResponse, responseItem);
}
}
public static ResponseItem <ClientDetail> GetByClient(int id_client)
{
var res = new ResponseItem <ClientDetail>();
res.data = new ClientDetail();
res.data.payments = new List <ClientPayment>();
try
{
var client = Clients.GetById(id_client);
var payment_days = 1;
if (client.data.payment_type == 2)
{
payment_days = 7;
}
else if (client.data.payment_type == 3)
{
payment_days = 14;
}
else if (client.data.payment_type == 4)
{
payment_days = 30;
}
using MySqlConnection connection = new MySqlConnection("server=localhost; Database=expenses; uid=admin; Pwd=database123;");
connection.Open();
MySqlCommand command = connection.CreateCommand();
MySqlTransaction transaction = connection.BeginTransaction();
command.Connection = connection;
command.Transaction = transaction;
var sql = $"select * from expenses.clients_payments where id_client = {id_client}";
command.CommandText = sql;
var dr = command.ExecuteReader();
while (dr.Read())
{
if (dr != null)
{
var client_payment = new ClientPayment();
client_payment.id_client_payment = Convert.ToInt32(dr["id_client_payment"]);
client_payment.id_client = id_client;
client_payment.value = Convert.ToSingle(dr["value"]);
client_payment.date = Convert.ToDateTime(dr["date"]);
res.data.payments.Add(client_payment);
}
}
res.data.id_client = id_client;
res.data.name = client.data.name;
res.data.phone = client.data.phone;
res.data.identification = client.data.identification;
res.data.interest_rate = client.data.interest_rate;
res.data.loan = client.data.loan;
res.data.time_limit = client.data.time_limit;
res.data.payment_type = client.data.payment_type;
res.data.payment_paid = res.data.payments.Sum(x => x.value);
var interest_value = client.data.loan * (client.data.interest_rate / 100);
res.data.payment_owed = (client.data.loan + interest_value) - res.data.payments.Sum(x => x.value);
res.data.payment_scheduled = (client.data.loan + interest_value) / (client.data.time_limit / payment_days);
res.success = true;
dr.Close();
transaction.Commit();
}
catch (Exception ex)
{
res.errors.Add(ex.Message);
res.errors.Add(ex.StackTrace);
}
return(res);
}
public SYS_tblGroupUserDRO()
{
ResponseItem = new ResponseItem();
}
public ActionResult Details(int id)
{
ResponseItem <Patient> patient = patientService.GetPatient(id);
return(View());
}
public PRO_tblProvinceDRO()
{
ResponseItem = new ResponseItem();
}
public SYS_tblPermissionDRO()
{
ResponseItem = new ResponseItem();
}
public PRO_tblStallDRO()
{
ResponseItem = new ResponseItem();
}
public PRO_tblWarehouseDRO()
{
ResponseItem = new ResponseItem();
}
public PRO_tblWarehouseDRO()
{
ResponseItem = new ResponseItem();
}
public ResponseItem VoidTest(RequestItem Item)
{
ResponseItem re = new ResponseItem(Item);
re.RequestItem.RequestLog = re.RequestItem.RequestLog + "srv_start: " + DateTime.Now.ToString() + ",";
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
decimal? TR_SubmitMinHours = null;
Queries.GetQueries getQ = new Queries.GetQueries(_serviceconfigparameters);
RuntimeProperties _RuntimeProperties = new RuntimeProperties(_serviceconfigparameters);
_RuntimeProperties.GetPersonalProperties(Item.reqp_userid);
try
{
TR_SubmitMinHours = getQ.tbl_hrWorkingHourTemplate_MinHoursDaily(Item.reqp_userid, Item.reqp_date, _RuntimeProperties.CalendarName.GetValue());
// TRS_PrivateGetDailyHourLimitByUser(Item.reqp_date, Item.reqp_userid);
TR_SubmitMinHours = TR_SubmitMinHours == null ? Convert.ToDecimal(8.25) : TR_SubmitMinHours;
HelperClasses.Serializer srl = new HelperClasses.Serializer();
string hour = srl.NTSoftJsonSerialize(TR_SubmitMinHours.ToString());
re.ResponseBody = hour.Replace(",", ".");
re.RequestCompleted = true;
}
catch (Exception ex)
{
HelperClasses.ExceptionHandler.LogException(ex, srvcont, Item);
//re.ResponseBody = ex.ToString();
re.RequestCompleted = false;
}
re.RequestItem.RequestLog = re.RequestItem.RequestLog + "srv_finish: " + DateTime.Now.ToString() + ",";
return re;
}
public SYS_tblActionLogDRO()
{
ResponseItem = new ResponseItem();
}
public PSIntranet.Service.ResponseItem Test_TRS_Submit_Validation(PSIntranet.Service.RequestItem Item)
{
PSIntranet.Service.ResponseItem response = new ResponseItem(Item);
//Validation
// ValidationSettings settings = new ValidationSettings();
// settings.AddRule(TR_SumbitValidation.DataBaseEqualsUserInput);
// //settings.AddRule(TR_SumbitValidation.RequiredFieldsCompleted);
// //settings.AddRule(TR_SumbitValidation.IsForProperDay);
// //min óra validálásra épül a max óra validálás, ezért a min validálást előbb kell futtatni
// //settings.AddRule(TR_SumbitValidation.HasProperMinHours);
// //settings.AddRule(TR_SumbitValidation.HasProperMaxHours);
// //settings.AddRule(TR_SumbitValidation.OffDayIsProper);
// //settings.AddRule(TR_SumbitValidation.DayIsNotWeekend);
// Validator validator = new Validator();
// //ha bármelyik validálási szabály nem teljesül
// try
// {
// validator.Validate(Item, settings, srvcont);
// }
// catch (Exception ex)
// {
// }
// response.ResponseType = ResponseType.Message;
// response.ResponseHeader = srl.NTSoftJsonSerialize("Submit failed!");
// response.ResponseBody = srl.NTSoftJsonSerialize(validator.ValidationMessage);
// response.RequestCompleted = false;
// return response;
//}
//private List<Entities.EntityViews.tblTimeReport_Transaction_Input> GetTestData(int userId, DateTime SelectedDate)
//{
// var TestData = (from trDay in srvcont.DataContext.tbl_trTransaction.Where(w =>
// w.ID_hrStaff == userId && w.tbl_trDate.Date == SelectedDate.Date
// )
// select new Entities.EntityViews.tblTimeReport_Transaction_Input
// {
// Id = trDay.ID,
// Job_No = trDay.tbl_genJobList.JobNumber ?? "",
// Job_Name = trDay.tbl_genJobList.JobName ?? "",
// Job_Type = trDay.tbl_genJobList.tbl_genJobType.JobType ?? "",
// Job_Chargeable = trDay.tbl_genJobList.tbl_genJobType.tbl_genChNchOff.Description ?? "",
// ActivityCodeType = trDay.tbl_genActivityCode.tbl_genActivityCodeType.ID,
// TransactionNeeded = trDay.tbl_genActivityCode.TransactionNeeded ?? false,
// ActivityCode = trDay.tbl_genActivityCode.ActivityCode ?? "",
// TransactionNo = trDay.TransactionNo ?? 0,
// TransactionStatus = trDay.tbl_trTransactionStatus.Description ?? "",
// BusinessUnit = trDay.tbl_genBusinessUnit.BusinessUnit ?? "",
// LocationInOut = trDay.tbl_genLocationInOut.LocationInOut ?? "",
// ReasonCode = trDay.tbl_genReasonCode.ReasonCode ?? "",
// Description = trDay.Description ?? "",
// Hour = trDay.Hour ?? 0
// }).ToList();
return null;
}
public virtual ActionResult RevokeModulesForRole(string RoleId, string Modules)
{
//JsonResponse response = new JsonResponse();
//response.Messages = new List<ResponseItem>();
//string[] moduleIds = Modules.Split(',');
//StringBuilder sb = new StringBuilder();
//ResponseItem item = null;
//foreach (string s in moduleIds)
//{
// if (!string.IsNullOrWhiteSpace(s))
// {
// try
// {
// //remove action in repo
// repoModulesInRole.DeleteByModule(new Guid(s));
// ////remove action in ModulesInRole
// //modulesInRoleRepo.RemoveAction(new Guid(moduleId), new Guid(s));
// ////remove all empty actions in ModulesInRole
// //modulesInRoleRepo.DeleteByModule(new Guid(moduleId));
// item = new ResponseItem();
// item.Success = true;
// response.Message = moduleRepo.FindByPk(new Guid(s)).ModuleName + " was removed successfully!";
// response.CssClass = "green";
// response.Messages.Add(item);
// }
// catch (Exception ex)
// {
// item = new ResponseItem();
// item.Success = false;
// response.Success = false;
// response.Message = ex.Message;
// response.CssClass = "red";
// response.Messages.Add(item);
// }
// }
//}
//return Json(response);
JsonResponse response = new JsonResponse();
response.Messages = new List <ResponseItem>();
string[] moduleIds = Modules.Split(',');
StringBuilder sb = new StringBuilder();
ResponseItem item = null;
try
{
roleRepo.AddModuleAndAction(moduleIds, RoleId);
item = new ResponseItem();
item.Success = true;
response.Message = "modules was added successfully!";
response.CssClass = "green";
response.Messages.Add(item);
}
catch (Exception ex)
{
item = new ResponseItem();
item.Success = false;
if (moduleIds == null)
{
item = new ResponseItem();
item.Success = true;
response.Message = "modules was added successfully!";
response.CssClass = "green";
response.Messages.Add(item);
}
else
{
response.Success = false;
response.Message = ex.Message;
response.CssClass = "red";
response.Messages.Add(item);
}
}
return(Json(response));
}
public SYS_tblUserLevelDRO()
{
ResponseItem = new ResponseItem();
}
/// <summary>
/// Fetch a List of <see cref="ResponseItem"/> for display/processing.
/// </summary>
/// <returns>a List of <see cref="ResponseItem"/>.</returns>
static public List<ResponseItem> GetResponses()
{
List<ResponseItem> responseList = new List<ResponseItem>();
ResponseItem response = new ResponseItem();
for ( int questionIndex = 0; questionIndex < questionData.GetLength( 0 ); questionIndex++ )
{
response.QuestionNumber = ( questionIndex + 1 ).ToString( "D2" );
response.QuestionText = questionData[questionIndex, 0];
response.GiftScore = questionData[questionIndex, 1];
responseList.Add( response );
}
return responseList;
}
public PRO_tblLevel3DRO()
{
ResponseItem = new ResponseItem();
}
public PRO_tblDistrictDRO()
{
ResponseItem = new ResponseItem();
}
