public ActionResult AboutUs()
{
QueryDataContext loQContext = new QueryDataContext();
List <QueryModel> loq = new List <QueryModel>();
loq = loQContext.GetQueries();
var c = 0;
foreach (var d in loq)
{
if (d.Answer != null)
{
c++;
}
}
TempData["Q"] = loq.Count();
TempData["TA"] = c;
AdminDataContext loEduContext = new AdminDataContext();
List <UserModel> loUsers = new List <UserModel>();
loUsers = loEduContext.GetUsers();
TempData["U"] = loUsers.Count();
TempData["FC"] = loEduContext.GetFeedBacksAndComplaints().Count();
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
using (var obj = new QueryDataContext())
{
var res = QueryHelper.Context.tblSources.Where(a => a.LocationName.Contains(Session["Query"].ToString()) && a.FK_TypeId == Convert.ToInt64(Session["Type"]));
GridView1.DataSource = res;
GridView1.DataBind();
foreach (var item in res)
{
if (QueryHelper.Context.tblLogs.Count(a => a.FK_SourceId == item.Id && a.FK_UserID == QueryHelper.Context.tblUsers.Single(b => b.UserName == Session["UserName"].ToString()).Id) <= 0)
{
var log = new tblLog();
log.FK_SourceId = item.Id;
log.FK_UserID = QueryHelper.Context.tblUsers.Single(a => a.UserName == Session["UserName"].ToString()).Id;
log.Date = DateTime.Now;
obj.tblLogs.InsertOnSubmit(log);
obj.SubmitChanges();
}
}
}
}
}
public RavenDbQueryDataSource(QueryDataContext context, IDocumentSession session, string collectionId = null, string indexName = null, bool isMapReduce = false)
{
this.context = context;
this.session = session;
this.collectionId = collectionId ?? typeof(T).Name;
this.indexName = indexName;
this.isMapReduce = isMapReduce;
}
//Get Ans With Query
public ActionResult Answer(decimal QueryID = 0)
{
QueryDataContext loQueryContext = new QueryDataContext();
QueryModel loQuery = new QueryModel();
loQuery.loQueryData = loQueryContext.GetQueries(QueryID);
return(View("Answer", loQuery));
}
//get Queries
public ActionResult Queries()
{
QueryDataContext loQueryContext = new QueryDataContext();
List <QueryModel> loQueries = new List <QueryModel>();
loQueries = loQueryContext.GetQueries();
return(View(loQueries));
}
//Add new Answer
public ActionResult AddAnswer(QueryModel loAnsData)
{
QueryDataContext loAnsContext = new QueryDataContext();
loAnsData.UserID = Convert.ToDecimal(Session["UserID"]);
loAnsContext.Answer(loAnsData);
return(RedirectToAction("Answer", new { QueryID = loAnsData.QueryID }));
}
public DynamoDbQueryDataSource(QueryDataContext context, IPocoDynamo dynamo, bool allowScans = true)
: base(context)
{
this.db = dynamo;
this.modelDef = db.GetTableMetadata <T>();
isGlobalIndex = typeof(T).IsGlobalIndex();
this.allowScans = allowScans;
}
public static QueryDataSource <T> DynamoDbSource <T>(this QueryDataContext ctx, IPocoDynamo dynamo = null, bool allowScans = true)
{
if (dynamo == null)
{
dynamo = HostContext.TryResolve <IPocoDynamo>();
}
return(new DynamoDbQueryDataSource <T>(ctx, dynamo, allowScans));
}
//Add new Query
public ActionResult AddQuery(QueryModel loQueryData)
{
QueryDataContext loQueryContext = new QueryDataContext();
loQueryData.UserID = Convert.ToDecimal(Session["UserID"]);
//loQueryData.Query += loQueryData.Desc;
loQueryContext.Query(loQueryData);
return(RedirectToAction("Queries"));
}
public MongoDBDataSource(QueryDataContext context, IMongoClient client, string databaseId, string collectionId = null)
{
if (string.IsNullOrWhiteSpace(databaseId))
{
throw new ArgumentNullException("databaseId");
}
this.context = context;
db = client.GetDatabase(databaseId);
this.collectionId = collectionId ?? typeof(T).Name;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (var obj = new QueryDataContext())
{
var ty = new tblType();
ty.TypeName = txtType.Text;
obj.tblTypes.InsertOnSubmit(ty);
obj.SubmitChanges();
}
BindDropdown();
}
protected void Button2_Click(object sender, EventArgs e)
{
using (var obj = new QueryDataContext())
{
var source = new tblSource();
source.FK_TypeId = Convert.ToInt64(ddlTypes.SelectedValue);
source.Latitude = Convert.ToDecimal(HiddenField2.Value);
source.LocationName = HiddenField1.Value;
source.Lontitude = Convert.ToDecimal(HiddenField3.Value);
obj.tblSources.InsertOnSubmit(source);
obj.SubmitChanges();
}
}
public static MemoryDataSource <T> ServiceSource <T>(this QueryDataContext ctx, object requestDto)
{
var response = HostContext.AppHost.GetServiceGateway(ctx.Request).Send <object>(requestDto);
var results = GetResults <T>(response);
if (results == null)
{
throw new NotSupportedException("IEnumerable<{0}> could not be derived from Response {1} from Request {2}"
.Fmt(typeof(T).Name, response.GetType().Name, requestDto.GetType().Name));
}
return(new MemoryDataSource <T>(ctx, results));
}
protected void btnLogin_Click(object sender, EventArgs e)
{
using (var obj = new QueryDataContext())
{
if (QueryHelper.Context.tblUsers.Count(a => a.UserName == txtUsername.Text&&a.Password==txtPassword.Text) > 0)
{
Session["UserName"] = txtUsername.Text;
Response.Redirect("Default.aspx");
}
else
{
Label1.Text = "Incorrect username or password";
}
}
}
public CosmosDbQueryDataSource(QueryDataContext context, IDocumentClient client, string databaseId, string collectionId = null, string partitionKey = null, ConnectionPolicy connectionPolicy = null, RequestOptions requestOptions = null)
{
this.context = context;
this.client = client;
this.databaseId = databaseId ?? throw new ArgumentNullException("databaseId");
this.partitionKey = partitionKey;
this.collectionId = collectionId ?? typeof(T).Name;
this.connectionPolicy = connectionPolicy ?? new ConnectionPolicy
{
ConnectionMode = ConnectionMode.Direct,
ConnectionProtocol = Protocol.Tcp
};
this.requestOptions = requestOptions ?? new RequestOptions
{
ConsistencyLevel = ConsistencyLevel.Session
};
}
public static QueryDataSource <T> ServiceSource <T>(this QueryDataContext ctx, object requestDto, ICacheClient cache, TimeSpan?expiresIn = null, string cacheKey = null)
{
if (cacheKey == null)
{
cacheKey = "aqd:" + requestDto.ToGetUrl();
}
var cachedResults = cache.Get <List <T> >(cacheKey);
if (cachedResults != null)
{
return(new MemoryDataSource <T>(ctx, cachedResults));
}
var response = ServiceSource <T>(ctx, requestDto);
return(response.CacheMemorySource(cache, cacheKey, expiresIn));
}
protected void btnRegister_Click(object sender, EventArgs e)
{
using (var obj = new QueryDataContext())
{
if (QueryHelper.Context.tblUsers.Count(a => a.UserName == txtUsername.Text) > 0)
{
lblError.Text = "User Name already exists";
}
else
{
var user = new tblUser();
user.Date = DateTime.Now;
user.MailId = txtMailId.Text;
user.MobileNumber = Convert.ToInt64(txtMobileNumber.Text);
user.Password = txtPassword.Text;
user.UserName = txtUsername.Text;
obj.tblUsers.InsertOnSubmit(user);
obj.SubmitChanges();
Session["UserName"] = txtUsername.Text;
Response.Redirect("Default.aspx");
}
}
}
public static IQueryDataSource <T> CosmosDbDataSource <T>(this QueryDataContext context, IDocumentClient client, string databaseId, string collectionId, string partitionKey) => new CosmosDbQueryDataSource <T>(context, client ?? HostContext.TryResolve <IDocumentClient>(), databaseId, collectionId, partitionKey);
public static IQueryDataSource <T> RavenDbDataSource <T>(this QueryDataContext context, IDocumentSession session, string collectionId = null, string indexName = null, bool isMapReduce = false) => new RavenDbQueryDataSource <T>(context, session ?? HostContext.TryResolve <IDocumentSession>(), collectionId, indexName, isMapReduce);
public static IQueryDataSource <T> MongoDBDataSource <T>(this QueryDataContext context, IMongoClient client, string databaseId, string collectionId = null) => new MongoDBDataSource <T>(context, client ?? HostContext.TryResolve <IMongoClient>(), databaseId, collectionId);
public CosmosDbQueryDataSource(QueryDataContext context, IDocumentClient client, string databaseId, string collectionId = null, ConnectionPolicy connectionPolicy = null, RequestOptions requestOptions = null)
: this(context, client, databaseId, collectionId, null, connectionPolicy, requestOptions)
{
}
public static IQueryDataSource <T> CosmosDbDataSource <T>(this QueryDataContext context, IDocumentClient client, string databaseId, string collectionId, RequestOptions requestOptions = null) => new CosmosDbQueryDataSource <T>(context, client ?? HostContext.TryResolve <IDocumentClient>(), databaseId, collectionId, null, requestOptions);
public MongoDBDataSource(QueryDataContext context, IMongoDatabase database, string collectionId = null)
{
this.context = context;
db = database ?? throw new ArgumentNullException("database");
this.collectionId = collectionId ?? typeof(T).Name;
}
public static IQueryDataSource <T> MongoDBDataSource <T>(this QueryDataContext context, IMongoDatabase database = null, string collectionId = null) => new MongoDBDataSource <T>(context, database ?? HostContext.TryResolve <IMongoDatabase>(), collectionId);
