/// <summary>
/// Creates a new sub entity and assigns the parent entity specified in the query strings.
/// </summary>
/// <returns></returns>
public override IEntity Create()
{
IEntity entity = null;
using (LogGroup logGroup = LogGroup.Start("Preparing the form to create a new sub entity.", NLog.LogLevel.Debug))
{
if (EnsureAuthorised())
{
Guid parentID = Guid.Empty;
string parentUniqueKey = String.Empty;
if (QueryStrings.Available)
{
parentID = QueryStrings.GetID("Parent");
parentUniqueKey = QueryStrings.GetUniqueKey("Parent");
}
else
{
throw new InvalidOperationException("Query strings aren't available. Provide parent ID or parent unique key manually.");
}
LogWriter.Debug("Parent ID: " + parentID);
LogWriter.Debug("Parent unique key: " + parentUniqueKey);
entity = Create(parentID, parentUniqueKey);
}
}
return(entity);
}
/// <summary>
/// This method requires a user id in order to get a user object from the database.
/// </summary>
/// <param name="id">The id</param>
/// <returns>Returns a student object.</returns>
public Student getSingleStudent(int id)
{
QueryStrings queryStrings = new QueryStrings();
Student singleStudent = queryStrings.getSingleStudentById(id);
return(singleStudent);
}
/// <summary>
/// This method requires a course object to add a course entry to the database.
/// </summary>
/// <param name="course">The course object</param>
/// <returns>Returns a bool whether it succeeded or not.</returns>
public bool addCourse(Course course)
{
QueryStrings queryStrings = new QueryStrings();
string data = course.courseCode + "','" + course.name + "','" + course.schoolYear + "','" + course.blockPeriod + "','" + course.credits;
return(queryStrings.addCourse(course, data));
}
/// <summary>
/// This method requires a user id in order to get all the grades of that user.
/// </summary>
/// <param name="id">The id</param>
/// <returns>Returns a list of all grades of the selected user.</returns>
public List <PrestationIndicator> getAverageGradeById(int id)
{
QueryStrings queryStrings = new QueryStrings();
List <PrestationIndicator> gradeList = queryStrings.getAverageGradeById(id);
return(gradeList);
}
/// <summary>
/// This method requires a user id and gets all courses that the user is not subscribed to.
/// </summary>
/// <param name="id">The id</param>
/// <returns>Returns a list of the courses that the user is not subscribed to.</returns>
public List <Course> getNonSubscribedCourses(int id)
{
QueryStrings queryStrings = new QueryStrings();
List <Course> allCourses = queryStrings.getNonSubscribedCourses(id);
return(allCourses);
}
/// <summary>
/// This method gets all existing courses.
/// </summary>
/// <returns>Returns a list of all courses.</returns>
public List <Course> allCourses()
{
QueryStrings queryStrings = new QueryStrings();
List <Course> allCourses = queryStrings.getAllCourses();
return(allCourses);
}
/// <summary>
/// This method requires a user id in order to get a list of courses that the student has completed.
/// </summary>
/// <param name="id">The id</param>
/// <returns>Returns the list of courses completed by the student.</returns>
public List <Course> coursesByStudent(int id)
{
QueryStrings queryStrings = new QueryStrings();
List <Course> coursesByStudent = queryStrings.getCouresesbyStudentId(id);
return(coursesByStudent);
}
public void LargeTableHandling()
{
InitConnection();
IQTable orderTable = qbApp.GetTable(qbSettings["qbBigTable"]);
Query qry = new Query();
QueryStrings lstQry = new QueryStrings(1, ComparisonOperator.IR, "last 60 d",
LogicalOperator.NONE);
qry.Add(lstQry);
int maxRec = 100000;
orderTable.Query(qry, string.Format("skp-10.num-{0}", maxRec));
Assert.AreEqual(maxRec, orderTable.Records.Count);
HashSet <string> idLst = new HashSet <string>();
foreach (QRecord rec in orderTable.Records)
{
string id = (string)rec["Record ID#"];
if (idLst.Contains(id))
{
Assert.Fail("Duplicate ID found!");
}
else
{
idLst.Add(id);
}
}
}
public ActionResult Login(string returnUrl)
{
var context = new Context();
var log = new SysLogModel(context: context);
if (Sessions.LoggedIn())
{
if (QueryStrings.Bool("new"))
{
Authentications.SignOut();
}
log.Finish(context: context);
return(base.Redirect(Locations.Top()));
}
var html = UserUtilities.HtmlLogin(
context: context,
returnUrl: returnUrl,
message: Request.QueryString["expired"] == "1" && !Request.IsAjaxRequest()
? Messages.Expired().Text
: string.Empty);
ViewBag.HtmlBody = html;
log.Finish(context: context, responseSize: html.Length);
return(View());
}
public ActionResult MyEmployeeDashboardSpendingHoursEmployeeBUOrganization(string Date, string Name)
{
string FDate = Date.Split(':').First();
string LastDate = Date.Split(':').Last();
string EMpId = Name.Split('(').Last().Split(')').First();
int UserId = Convert.ToInt32(EMpId);// 60814;
DateTime Fromdate = Convert.ToDateTime(FDate);
DateTime ToDate = Convert.ToDateTime(LastDate);
DataTable BeingOntimeData = new QueryStrings().GetInOutTotalPunchData(FDate, LastDate, UserId);
List <DateTime> DateData = new List <DateTime>();
List <string> Datestringdata = new List <string>();
List <double> FirstPuch = new List <double>();
List <double> LastPuch = new List <double>();
List <double> Totalhoursspent = new List <double>();
for (DateTime date = Fromdate; date <= ToDate; date = date.AddDays(1.0))
{
DateData.Add(date);
Datestringdata.Add(date.ToString("dd-MMM"));
}
for (DateTime date = DateData[0]; date <= DateData[DateData.Count - 1]; date = date.AddDays(1.0))
{
string firstpunch = GetFirstPunchTimeValue(BeingOntimeData, date);
var data = firstpunch.Split(':');
string time = data[0] + "." + data[1];
FirstPuch.Add(Convert.ToDouble(time));
}
for (DateTime date = DateData[0]; date <= DateData[DateData.Count - 1]; date = date.AddDays(1.0))
{
string firstpunch = GetLastPuchTimeValue(BeingOntimeData, date);
var data = firstpunch.Split(':');
string time = data[0] + "." + data[1];
LastPuch.Add(Convert.ToDouble(time));
}
for (DateTime date = DateData[0]; date <= DateData[DateData.Count - 1]; date = date.AddDays(1.0))
{
string firstpunch = GetTotalhoursTimeValue(BeingOntimeData, date);
var data = firstpunch.Split(':');
string time = data[0] + "." + data[1];
Totalhoursspent.Add(Convert.ToDouble(time));
}
ArrayList EmployeeDashboardSpendingstatistics = new ArrayList();
//string[] categories = new string[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" };
//double[] Selecteduserdata = new double[] { 8.0, 6.9, 9.5, 8.5, 10.4, 9.5, 9.2, 8.5, 9.3, 7.3, 6.9, 9.6 };
//double[] BUdata = new double[] { 8.9, 2.2, 5.7, 8.5, 11.9, 15.2, 17.0, 12.6, 12.2, 10.3, 6.6, 4.8 };
//double[] Organizationdata = new double[] { 8.9, 8.2, 5.7, 8.5, 7.9, 8.2, 17.0, 9.6, 10.2, 9.3, 8.6, 10.8 };
EmployeeDashboardSpendingstatistics.Add(Datestringdata.ToArray());
EmployeeDashboardSpendingstatistics.Add(FirstPuch.ToArray());
EmployeeDashboardSpendingstatistics.Add(LastPuch.ToArray());
EmployeeDashboardSpendingstatistics.Add(Totalhoursspent.ToArray());
return(Json(EmployeeDashboardSpendingstatistics, JsonRequestBehavior.AllowGet));
}
public void ClearQueryStrings()
{
QueryStrings.Clear();
if (PageUrl != null)
{
SetPageUrl(new Uri(PageUrl).AbsolutePath);
}
}
/// <summary>
/// This method requires a username in order to get the role id of that user.
/// </summary>
/// <param name="username">The username</param>
/// <returns>Returns the role id.</returns>
public int returnRoleId(string username)
{
QueryStrings queryStrings = new QueryStrings();
UserAccount user = new UserAccount();
user = queryStrings.selectSingleUser(username);
return(user.roleId);
}
/// <summary>
/// This method requires a username in order to get the username of that user.
/// </summary>
/// <param name="username">The username</param>
/// <returns>Returns the username.</returns>
public string returnUsername(string username)
{
QueryStrings queryStrings = new QueryStrings();
UserAccount user = new UserAccount();
user = queryStrings.selectSingleUser(username);
return(user.username);
}
/// <summary>
/// This method requires a user id in order to get all the prestation indicators of that user.
/// </summary>
/// <param name="id">The id</param>
/// <returns>Returns a list of all the prestation indicators of the selected user.</returns>
public List <PrestationIndicator> getPrestationIndicatorsById(int id)
{
// return list of prestation indicators
QueryStrings queryStrings = new QueryStrings();
List <PrestationIndicator> piList = queryStrings.getPrestationIndicatorsById(id);
return(piList);
}
public ActionResult MyEmployeeDashboard()
{
DataTable EmployeeNames = new QueryStrings().GetUserNames();
var data = from dt in EmployeeNames.AsEnumerable()
select dt.Field <string>("users");
ViewBag.Names = data.ToList();
return(View());
}
/// <summary>
/// Method using for generating uri with custom attributes.
/// </summary>
/// <param name="pageName">Page name.</param>
/// <param name="item">QuerString item which contains atttribute and value.</param>
/// <returns>Return query string.</returns>
protected string GenerateURI(string pageName, QueryStrings item)
{
string querystring = "";
if (item != null)
{
querystring = GetQueryStringBuilderInstance().AddQueryItem(item);
}
return(pageName + "?" + querystring);
}
/// <summary>
/// Fixed:
/// </summary>
public static string Search()
{
var dataSet = Get(
searchIndexes: QueryStrings.Data("text").SearchIndexes(),
offset: QueryStrings.Int("offset"),
pageSize: Parameters.General.SearchPageSize);
return(MainContainer(
text: QueryStrings.Data("text"),
offset: 0,
results: dataSet?.Tables["Main"].AsEnumerable(),
count: Rds.Count(dataSet)).ToString());
}
/// <summary>
/// Fixed:
/// </summary>
public static string Search()
{
var ss = new SiteSettings();
var dataSet = Get(
searchText: QueryStrings.Data("text"),
dataTableName: "SearchResults",
offset: QueryStrings.Int("offset"),
pageSize: Parameters.General.SearchPageSize);
return(MainContainer(
ss: ss,
text: QueryStrings.Data("text"),
offset: 0,
results: dataSet?.Tables["SearchResults"].AsEnumerable(),
count: Rds.Count(dataSet)).ToString());
}
public ActionResult MyEmployeeDashboardSpendingHours(string Date, string Name)
{
string FDate = Date.Split(':').First();
string LastDate = Date.Split(':').Last();
string EMpId = Name.Split('(').Last().Split(')').First();
int UserId = Convert.ToInt32(EMpId);// 60814;
DateTime Fromdate = Convert.ToDateTime(FDate);
DateTime ToDate = Convert.ToDateTime(LastDate);
DataTable BeingOntimeData = new QueryStrings().GetBeingOntimeData(FDate, LastDate, UserId);
ArrayList EmployeeDashboardSpendingstatistics = new ArrayList();
#region commneted
//string[] time = new string[] { "7:00", "7:30", "8:00", "8:30", "9:00", "9:30", "10:00", "10:30", "11:00", "11:30", "12:00", "12:30", "13:00", };
//int[] count = new int[] { 40, 10, 94, 272, 320, 10, 50, 2, 3, 7, 1, 2, 6 };
// var time = BeingOntimeData.AsEnumerable().Select(r => r[1]).ToList();
// var count = BeingOntimeData.AsEnumerable().Select(r => r[2]).ToList();
#endregion
List <DateTime> DateData = new List <DateTime>();
List <string> CountData = new List <string>();
for (DateTime date = Fromdate; date <= ToDate; date = date.AddDays(1.0))
{
DateData.Add(date);
}
for (DateTime date = DateData[0]; date <= DateData[DateData.Count - 1]; date = date.AddDays(1.0))
{
CountData.Add(GetTimeValue(BeingOntimeData, date));
}
for (int i = 0; i < CountData.Count(); i++)
{
string att_time = DateData[i].ToString("dd-MMM-yy");
string attendance = CountData[i].ToString();
EmployeeDashboardSpendingstatistics.Add(new
{
att_time,
attendance
});
}
return(Json(EmployeeDashboardSpendingstatistics, JsonRequestBehavior.AllowGet));
}
private void ucf2_btnAddEventClick(object sender, EventArgs e)
{
UserControlGraph ucf2 = (UserControlGraph)sender;
if (PrincipalHelper.GetUserPrincipal().HasSupervisor&& (model.StrankaZaposleni != null && model.StrankaZaposleni.Count > 0))
{
List <QueryStrings> queryList = new List <QueryStrings>();
int employeeID = 0;
if (model != null)
{
employeeID = model.StrankaZaposleni[0].idOsebe;
}
QueryStrings item = new QueryStrings()
{
Attribute = Enums.QueryStringName.action.ToString(), Value = "1"
};
queryList.Add(item);
item = new QueryStrings()
{
Attribute = Enums.QueryStringName.recordId.ToString(), Value = "0"
};
queryList.Add(item);
item = new QueryStrings()
{
Attribute = Enums.QueryStringName.eventClientId.ToString(), Value = clientID.ToString()
};
queryList.Add(item);
item = new QueryStrings()
{
Attribute = Enums.QueryStringName.eventCategorieId.ToString(), Value = ucf2 != null?ucf2.CategorieID.ToString() : (-1).ToString()
};
queryList.Add(item);
item = new QueryStrings()
{
Attribute = Enums.QueryStringName.eventEmployeeId.ToString(), Value = employeeID.ToString()
};
queryList.Add(item);
ClearSessionsAndRedirect(true, GenerateURI("../Events/EventsForm.aspx", queryList));
}
else
{
ErrorLabel.Text = "Skrbnik in zaposlen za stranko ni izbran!";
}
}
public IQueryable <DTO_CUS_DOC_File> Get()
{
var result = BS_CUS_DOC_File.get_CUS_DOC_File(db, PartnerID, QueryStrings, true).ToList();
if (QueryStrings.Any(d => d.Key == "IncludeOwner"))
{
var query = db.tbl_CUS_DOC_File
.Where(d => d.IsDeleted == false && d.IsHidden != true && d.IDPartner == PartnerID && (d.ModifiedBy == Username || d.CreatedBy == Username));
if (QueryStrings.Any(d => d.Key == "IDFolder"))
{
var IDList = QueryStrings.FirstOrDefault(d => d.Key == "IDFolder").Value.Replace("[", "").Replace("]", "").Split(',');
List <int> IDs = new List <int>();
foreach (var item in IDList)
{
if (int.TryParse(item, out int i))
{
IDs.Add(i);
}
else if (item == "null")
{
query = query.Where(d => !d.tbl_CUS_DOC_FileInFolder.Any());
}
}
if (IDs.Count > 0)
{
query = query.Where(d => d.tbl_CUS_DOC_FileInFolder.Any(c => c.IDFolder.HasValue && IDs.Contains(c.IDFolder.Value)));
}
}
var result2 = BS_CUS_DOC_File.ctoDTO(query).ToList();
if (result2.Count > 0)
{
foreach (var item in result2)
{
if (!result.Any(d => d.ID == item.ID))
{
result.Add(item);
}
}
}
}
return(result.AsQueryable());
}
/// <summary>
/// Fixed:
/// </summary>
public static string SearchJson(Context context)
{
var ss = new SiteSettings();
var offset = QueryStrings.Int("offset");
var searchText = QueryStrings.Data("text");
var dataSet = Get(
context: context,
searchText: searchText,
dataTableName: "SearchResults",
offset: offset,
pageSize: Parameters.General.SearchPageSize);
var dataRows = dataSet?.Tables["SearchResults"].AsEnumerable();
var res = new ResponseCollection();
return(offset == 0
? res
.ReplaceAll(
"#MainContainer",
MainContainer(
context: context,
ss: ss,
text: searchText,
offset: 0,
results: dataRows,
count: Rds.Count(dataSet)))
.Focus("#Search")
.ToJson()
: res
.Append(
"#SearchResults",
new HtmlBuilder().Results(
context: context,
ss: ss,
text: searchText,
offset: offset,
dataRows: dataRows))
.Val(
"#SearchOffset",
(dataRows != null &&
dataRows.Any() &&
dataRows.Count() == Parameters.General.SearchPageSize
? offset + Parameters.General.SearchPageSize
: -1).ToString())
.ToJson());
}
/// <summary>
/// Displays the page for viewing an entity.
/// </summary>
public virtual void View <T>()
where T : IEntity
{
Guid id = QueryStrings.GetID(Command.TypeName);
string uniqueKey = QueryStrings.GetUniqueKey(Command.TypeName);
if (id != Guid.Empty)
{
View <T>(id);
}
else if (uniqueKey != String.Empty)
{
View <T>(uniqueKey);
}
else
{
throw new InvalidOperationException("Cannot view entity. No identifier found.");
}
}
/// <summary>
/// Loads the entity specified by the query string and prepares it for viewing.
/// </summary>
/// <returns>The entity specified by the query string.</returns>
public virtual T PrepareView <T>()
where T : IEntity
{
Guid goalID = QueryStrings.GetID(Command.TypeName);
string goalKey = QueryStrings.GetUniqueKey(Command.TypeName);
if (goalID != Guid.Empty)
{
return((T)LoadEntity <T>(goalID));
}
else if (goalKey != String.Empty)
{
return((T)LoadEntity <T>(goalKey));
}
else
{
throw new InvalidOperationException("Cannot find entity ID or unique key in query string.");
}
}
/// <summary>
/// Fixed:
/// </summary>
public static bool Login(Context context)
{
var demoModel = new DemoModel().Get(
context: context,
where : Rds.DemosWhere()
.Passphrase(QueryStrings.Data("passphrase"))
.CreatedTime(
DateTime.Now.AddDays(Parameters.Service.DemoUsagePeriod * -1),
_operator: ">="));
if (demoModel.AccessStatus == Databases.AccessStatuses.Selected)
{
var loginId = LoginId(demoModel, "User1");
var password = Strings.NewGuid().Sha512Cng();
if (!demoModel.Initialized)
{
var idHash = new Dictionary <string, long>();
demoModel.Initialize(context: context, idHash: idHash, password: password);
}
else
{
Rds.ExecuteNonQuery(
context: context,
statements: Rds.UpdateUsers(
param: Rds.UsersParam().Password(password),
where : Rds.UsersWhere().LoginId(loginId)));
}
new UserModel()
{
LoginId = loginId,
Password = password
}.Authenticate(
context: context,
returnUrl: string.Empty);
SiteInfo.Reflesh(context: context, force: true);
return(Sessions.LoggedIn());
}
else
{
return(false);
}
}
public ActionResult Inpunch()
{
DataTable hourwiseData = new QueryStrings().GetInpunhData(DateTime.Now.ToString("yyyy-MM-dd"));
//DataTable hourwiseData = new QueryStrings().GetInpunhData("2018-02-22");
ArrayList plannedvsunplanned = new ArrayList();
var Time = Enumerable.Range(0, 24).ToArray();
List <int> Data = new List <int>();
for (int hour = 0; hour < 24; hour++)
{
// plannedvsunplanned.Add(hour.ToString());
Data.Add(GetHourValue(hourwiseData, hour));
}
plannedvsunplanned.Add(Time);
plannedvsunplanned.Add(Data.ToArray());
return(Json(plannedvsunplanned, JsonRequestBehavior.AllowGet));
}
private static String RedirectToEvent(int eventID, int clientID, int categorieID, int employeeID = 0)
{
List <QueryStrings> queryList = new List <QueryStrings>();
QueryStrings item = new QueryStrings()
{
Attribute = Enums.QueryStringName.action.ToString(), Value = "2"
}; //edit
queryList.Add(item);
item = new QueryStrings()
{
Attribute = Enums.QueryStringName.recordId.ToString(), Value = eventID.ToString()
};
queryList.Add(item);
item = new QueryStrings()
{
Attribute = Enums.QueryStringName.eventClientId.ToString(), Value = clientID.ToString()
};
queryList.Add(item);
item = new QueryStrings()
{
Attribute = Enums.QueryStringName.eventCategorieId.ToString(), Value = categorieID.ToString()
};
queryList.Add(item);
item = new QueryStrings()
{
Attribute = Enums.QueryStringName.eventEmployeeId.ToString(), Value = employeeID.ToString()
};
queryList.Add(item);
QueryStringBuilder instance = new QueryStringBuilder(queryList);
if (HttpContext.Current.Request.IsLocal)
{
return("/Pages/CodeList/Events/EventsForm.aspx?" + instance.GenerateQueryString());
}
else
{
return(ConfigurationManager.AppSettings["ServerTag"].ToString() + "Pages/CodeList/Events/EventsForm.aspx?" + instance.GenerateQueryString());
}
}
private void Parse(string queryString)
{
string[] parts = queryString.Split('&');
foreach (string part in parts)
{
int equalToPosition = part.IndexOf('=');
string name = part.Substring(0, equalToPosition);
string val = part.Substring(equalToPosition + 1);
val = HttpUtility.UrlDecode(val);
if (StringHelper.IsEqual(name, ENCRYPTED_KEY))
{
if (val.Length > 0)
{
string decryptedString = HttpUtility.UrlDecode(StringHelper.Decrypt(val));
string[] keyValue = decryptedString.Split('&');
for (int i = 0; i < keyValue.Length; i++)
{
string param = keyValue[i];
equalToPosition = param.IndexOf('=');
if (equalToPosition > 0)
{
string paramName = param.Substring(0, equalToPosition);
string paramValue = param.Substring(equalToPosition + 1);
QueryStrings.Add(paramName, paramValue);
}
}
}
}
else
{
QueryStrings.Add(name, val);
}
}
}
public string Remind()
{
if (Parameters.Reminder.Enabled)
{
if (QueryStrings.Bool("NoLog"))
{
return(ReminderScheduleUtilities.Remind());
}
else
{
var log = new SysLogModel();
var json = ReminderScheduleUtilities.Remind();
log.Finish(json.Length);
return(json);
}
}
else
{
return(null);
}
}
public string Do()
{
if (Parameters.BackgroundTask.Enabled)
{
if (QueryStrings.Bool("NoLog"))
{
return(BackgroundTasks.Do());
}
else
{
var log = new SysLogModel();
var html = BackgroundTasks.Do();
log.Finish(html.Length);
return(html);
}
}
else
{
return(null);
}
}
