public String GetGridIds(
string entityName,
string filter,
string parentProjectionName,
int?parentEntityId,
string projectionRelationName,
bool ignoreSwitchIsVisibleOnFilter
)
{
string jsonFinal = string.Empty;
TemplateQueryBuilder queryBuilder = new TemplateQueryBuilder();
string sql = queryBuilder.GetGridIdsQuery(
entityName,
this.userInfo,
filter,
parentProjectionName,
parentEntityId,
projectionRelationName,
ignoreSwitchIsVisibleOnFilter
);
auditService.SetQueryBuilderSql(sql);
using (SqlConnection conn = new SqlConnection(DbConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@userId", this.userInfo.UserId));
SqlDataReader rdr = cmd.ExecuteReader();
StringBuilder json = new StringBuilder();
while (rdr.Read())
{
json.Append(rdr.GetString(0));
}
jsonFinal = json.ToString();
}
return(jsonFinal);
}
public String GetCalendarAppointments(DateTime startDate, DateTime endDate, Dictionary <string, List <int> > entitiesAndRoles, List <int> userIDs)
{
List <Event> events = new List <Event>();
TemplateQueryBuilder queryBuilder = new TemplateQueryBuilder();
string sql = queryBuilder.GetCalendarEntities(entitiesAndRoles, userIDs, this.userInfo);
auditService.SetQueryBuilderSql(sql);
using (SqlConnection conn = new SqlConnection(DbConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@userId", this.userInfo.UserId));
cmd.Parameters.Add(new SqlParameter("@profileId", this.userInfo.ProfileId));
cmd.Parameters.Add(new SqlParameter("@userLanguage", this.userInfo.UserLanguage));
cmd.Parameters.Add(new SqlParameter("@userLanguageId", this.userInfo.UserLanguageId));
cmd.Parameters.Add(new SqlParameter("@fromDate", startDate));
cmd.Parameters.Add(new SqlParameter("@toDate", endDate));
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
events.Add(
new Event()
{
id = (string)rdr["EntityName"] + (int)rdr["Id"],
entityName = (string)rdr["EntityName"],
entityId = (int)rdr["Id"],
title = (string)rdr["Name"],
start = ((DateTime)rdr["StartDate"]).ToString("yyyy-MM-ddTHH:mm:ss"),
end = (DateTime)rdr["EndDate"] <= (DateTime)rdr["StartDate"] ? ((DateTime)rdr["StartDate"]).AddMinutes(15).ToString("yyyy-MM-ddTHH:mm:ss") : ((DateTime)rdr["EndDate"]).ToString("yyyy-MM-ddTHH:mm:ss"),
allDay = (bool)rdr["IsAllDay"],
color = (string)rdr["CalendarBackgroundColor"]
}
);
}
}
return(JsonConvert.SerializeObject(events));
}
public String UpdateCalendarData(string entityName, int entityId, DateTime startDate, DateTime endDate)
{
TemplateQueryBuilder queryBuilder = new TemplateQueryBuilder();
string sql = queryBuilder.UpdateCalendarEntity(entityName, this.userInfo);
auditService.SetQueryBuilderSql(sql);
using (SqlConnection conn = new SqlConnection(DbConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@userId", this.userInfo.UserId));
cmd.Parameters.Add(new SqlParameter("@entityId", entityId));
cmd.Parameters.Add(new SqlParameter("@startDate", startDate));
cmd.Parameters.Add(new SqlParameter("@endDate", endDate));
cmd.ExecuteNonQuery();
return("{}");
}
}
