public IHttpActionResult Sendotp(string id)
{
Otp model = new Otp();
try
{
model.MobileOtp = sendOtp.GenerateOtp();
var userDocument = _bucket.Query <object>(@"SELECT mobileNo,emailId From ICADB where id= '" + id + "'").ToList();
if (userDocument.Count == 0)
{
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "175-please enter valid emiratid"), new JsonMediaTypeFormatter()));
}
else
{
JObject jsonObj = JObject.Parse(userDocument[0].ToString());
//string mobileNo = (string)jsonObj["mobileNo"];
model.Email = (string)jsonObj["emailId"];;
model.MobileNo = (string)jsonObj["mobileNo"];
model.MobileOtp = model.MobileOtp;
mobileSMS.SendOtpViaMobile(model.MobileNo, model.MobileOtp, model.Email);
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, model.Email), new JsonMediaTypeFormatter()));
}
}
catch (Exception ex)
{
return(Content(HttpStatusCode.Forbidden, MessageResponse.Message(HttpStatusCode.Forbidden.ToString(), ex.Message), new JsonMediaTypeFormatter()));
}
}
public void Test_QueryNoDeadlock()
{
// Using an asynchronous HttpClient request within an MVC Web API action may cause
// a deadlock when we wait for the result synchronously.
var context = new Mock<SynchronizationContext>
{
CallBase = true
};
SynchronizationContext.SetSynchronizationContext(context.Object);
try
{
_bucket.Query<dynamic>("SELECT * FROM `beer-sample` LIMIT 10");
// If view queries are incorrectly awaiting on the current SynchronizationContext
// We will see calls to Post or Send on the mock
context.Verify(m => m.Post(It.IsAny<SendOrPostCallback>(), It.IsAny<object>()), Times.Never);
context.Verify(m => m.Send(It.IsAny<SendOrPostCallback>(), It.IsAny<object>()), Times.Never);
}
finally
{
SynchronizationContext.SetSynchronizationContext(null);
}
}
public int GetCountOfAllSessions()
{
var n1ql = @"SELECT VALUE COUNT(*) FROM `" + _bucket.Name + "`";
var query = QueryRequest.Create(n1ql);
return(_bucket.Query <int>(query).Rows.First());
}
public List <dynamic> GetTaskById(string taskId)
{
var queryStr = @"SELECT
p._id AS projectId,
(SELECT _id,
(SELECT a.* FROM `" + _bucket.Name + @"` a USE KEYS c.assignedTo)[0] AS assignedTo,
createdON,
description,
(select
t.log,
t.createdAt,
(SELECT u.* FROM `" + _bucket.Name + @"` u USE KEYS t.`user`)[0] AS `user` FROM `" + _bucket.Name + @"` r UNNEST r.history t WHERE r._id = $1) AS history,
name,
(SELECT o.*FROM `" + _bucket.Name + @"` o USE KEYS c.owner)[0] as owner,
(SELECT u.* FROM `" + _bucket.Name + @"` u USE KEYS c.users) AS users, permalink
FROM `" + _bucket.Name + @"` c
WHERE c._id= $1)[0] AS task
FROM `" + _bucket.Name + @"` p
WHERE ANY x IN tasks SATISFIES x = $1 END ";
var query = QueryRequest.Create(queryStr);
query.ScanConsistency(ScanConsistency.RequestPlus);
query.AddPositionalParameter(taskId);
var queryResult = _bucket.Query <dynamic>(query);
return(ExtractResultOrThrow(queryResult));
}
public IEnumerable <Type> ExecQueryReturnList(IQueryRequest queryRequest)
{
var result = _bucket.Query <Type>(queryRequest);
if (result.Errors.Count > 0)
{
throw new Exception(result.Errors[0].Message);
}
return(result.Rows);
}
public IHttpActionResult GetCommonMasters(string name)
{
//string query = @"SELECT Contents." + name + " From " + _bucket.Name + " as cmt where meta().id='REF_EN_US'";
string query = @"SELECT r.* FROM APTCREF AS d USE KEYS[""REF_EN_US""] UNNEST d.['"+ name + "'] AS r";
var CommonMasterDocument = _bucket.Query<object>(query).ToList();
return Content(HttpStatusCode.OK, CommonMasterDocument);
}
public ActionResult GetByIp(string ip)
{
var n1ql = $"SELECT *, META().id FROM {ConfigurationDefaults.COUCHBASE_COLLECTIONNAME} WHERE Ip = $ip";
var query = QueryRequest.Create(n1ql);
query.AddNamedParameter("$ip", ip);
query.ScanConsistency(ScanConsistency.RequestPlus);
var result = _bucket.Query <object>(query);
return(new JsonResult(result));
}
public void Execute_Query()
{
const string statement = "SELECT \"hello\" as greeting;";
var query = new AnalyticsRequest(statement);
var result = _bucket.Query <TestRequest>(query);
Assert.IsTrue(result.Success);
Assert.AreEqual("hello", result.Rows.First().Greeting);
}
public List <Company> GetCompanyById(string companyId)
{
var queryStr = "SELECT companies.* FROM `" + _bucket.Name + @"` AS companies
WHERE _type = 'Company' AND META(companies).id = $1";
var query = QueryRequest.Create(queryStr);
query.ScanConsistency(ScanConsistency.RequestPlus);
query.AddPositionalParameter(companyId);
var queryResult = _bucket.Query <Company>(query);
return(ExtractResultOrThrow(queryResult));
}
public List <User> GetUserById(string userId)
{
var queryStr = @"SELECT users.*
FROM `" + _bucket.Name + @"` AS users
WHERE _type = 'User' AND META(users).id = $1";
var query = QueryRequest.Create(queryStr);
query.ScanConsistency(ScanConsistency.RequestPlus);
query.AddPositionalParameter(userId);
var queryResult = _bucket.Query <User>(query);
return(ExtractResultOrThrow(queryResult));
}
public IActionResult GetAll()
{
//var n1ql = @" select g.*, META(g).Id
// from demo g where g.type='wishlistItem';";
var n1ql = @" SELECT id,country,name,type FROM `travel-sample`;";
var query = QueryRequest.Create(n1ql);
query.ScanConsistency(ScanConsistency.RequestPlus);
var result = _buckate.Query <WishlistItem>(query);
return(Ok(result.Rows));
}
/// <summary>
/// Lists the indexes for the current <see cref="IBucket" />.
/// </summary>
/// <returns></returns>
public virtual IndexResult ListN1qlIndexes()
{
var request = new QueryRequest(string.Format(Statements.ListIndexes, BucketName));
var result = _bucket.Query <IndexInfo>(request);
return(new IndexResult
{
Value = result.Rows,
Exception = result.Exception,
Message = result.Message,
Success = result.Success
});
}
public IActionResult Login(string email, string pass)
{
var n1ql = "SELECT t.* FROM todoBucket t WHERE t.email = $email AND t.pass = $pass ";
var query = QueryRequest.Create(n1ql);
query.AddNamedParameter("$email", email).AddNamedParameter("$pass", pass);
var result = _bucket.Query <User>(query).FirstOrDefault();
if (result == null)
{
return(BadRequest());
}
return(Ok(result));
}
/// <summary>
/// Execute a <see cref="LinqQueryRequest"/>.
/// </summary>
/// <typeparam name="T">Type returned by the query.</typeparam>
/// <param name="queryRequest">Request to execute.</param>
/// <returns>List of objects returned by the request.</returns>
public IEnumerable <T> ExecuteCollection <T>(LinqQueryRequest queryRequest)
{
if (!queryRequest.ScalarResultBehavior.ResultExtractionRequired)
{
var result = _bucket.Query <T>(queryRequest);
return(ParseResult(result));
}
else
{
var result = _bucket.Query <ScalarResult <T> >(queryRequest);
return(queryRequest.ScalarResultBehavior.ApplyResultExtraction(ParseResult(result)));
}
}
public void GetAllCouncils()
{
var n1ql = @"SELECT c.*, META(c).id
FROM lawyermanagementdb c
WHERE c.type = 'Council';";
var query = QueryRequest.Create(n1ql);
query.ScanConsistency(ScanConsistency.RequestPlus);
var result = _bucket.Query <Council>(query);
foreach (Council council in result)
{
_councils.Add(council);
}
}
public void GetAllBookings()
{
var n1ql = @"SELECT b.*, META(b).id
FROM lawyermanagementdb b
WHERE b.type = 'Booking';";
var query = QueryRequest.Create(n1ql);
query.ScanConsistency(ScanConsistency.RequestPlus);
var result = _bucket.Query <Booking>(query);
foreach (Booking booking in result)
{
_bookings.Add(booking);
}
}
public IHttpActionResult GetDepartments()
{
try
{
string Query = @"SELECT * From " + _bucket.Name + " as APTCREF where meta().id='Departments'";
var userDocument = _bucket.Query <object>(Query).ToList();
JObject jsonObj = JObject.Parse(userDocument[0].ToString());
JObject jsonDept = JObject.Parse(jsonObj["APTCREF"]["Dept"].ToString());
return(Content(HttpStatusCode.OK, ((System.Collections.Generic.IDictionary <string, Newtonsoft.Json.Linq.JToken>)jsonDept).Keys));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
// tag::GetTenLatestUpdates[]
public List <Update> GetTenLatestUpdates()
{
var n1ql = @"SELECT up.body, up.postedDate, { 'id': META(u).id, u.name} AS `user`
FROM `sqltocb` up
JOIN `sqltocb` u ON KEYS up.`user`
WHERE up.type = 'Update'
ORDER BY STR_TO_MILLIS(up.postedDate) DESC
LIMIT 10;";
var query = QueryRequest.Create(n1ql);
query.ScanConsistency(ScanConsistency.RequestPlus);
var result = _bucket.Query <Update>(query);
return(result.Rows);
}
public IHttpActionResult GetLogin(string id)
{
try
{
var userDocument = _bucket.Query <object>(@"SELECT loginDetails From " + _bucket.Name + " where email= '" + id + "'").ToList();
if (userDocument.Count == 0)
{
return(Content(HttpStatusCode.NoContent, "176-plaese enter valid user id."));
}
else
{
JObject jsonObj = JObject.Parse(userDocument[0].ToString());
Login login = new Login();
login.UserId = id;
login.Password = jsonObj["loginDetails"]["password"].ToString();
login.Type = (string)jsonObj["loginDetails"]["type"].ToString();
login.LoginStatus = (bool)jsonObj["loginDetails"]["loginStatus"];
JObject jsonmobRoleObj = JObject.Parse(jsonObj["loginDetails"]["userRole"].ToString());
//Department userDepartment = new Department();
//userDepartment.DepartmentName = jsonmobRoleObj["userRoleName"].ToString();
//login.Department= mod;
return(Content(HttpStatusCode.OK, login));
}
}
catch (Exception ex)
{
return(Content(HttpStatusCode.Forbidden, ex.Message));
}
}
/* Função para demonstrar o uso do */
static void MapReduce()
{
Console.WriteLine("Map/Reduce");
Console.WriteLine("");
ClientConfiguration config = new ClientConfiguration()
{
Servers = new List <Uri>()
{
new Uri("http://localhost:8091")
}
};
config.SetAuthenticator(new PasswordAuthenticator("test", "123456"));
using (Cluster cluster = new Cluster(config))
using (IBucket bucket = cluster.OpenBucket("viajanet"))
{
IViewQuery query = new ViewQuery().From("clients", "clientCountNavigation").GroupLevel(2);
IViewResult <dynamic> clientNavigation = bucket.Query <dynamic>(query);
string userToken = "";
foreach (var client in clientNavigation.Rows)
{
if (client.Key[0] != userToken)
{
Console.WriteLine("Client {0}", client.Key[0]);
userToken = client.Key[0];
}
Console.WriteLine(" Function: {0} -> Count: {1}", client.Key[1], client.Value);
}
}
}
public IActionResult SearchAddress(string address = "")
{
if (!string.IsNullOrEmpty(address))
{
var query = new SearchQuery
{
Index = "fts_index",
Query = new MatchQuery(address)
}
.Limit(10);
var result = bucket.Query(query);
List <Landmark> landmarks = new List <Landmark>();
ISearchQueryResult searchQueryRows = result;
foreach (var item in searchQueryRows)
{
var landmark = bucket.GetDocument <Landmark>(item.Id).Document.Content;
landmarks.Add(landmark);
}
return(View(landmarks));
}
else
{
List <Landmark> landmarks = new List <Landmark>();
return(View(landmarks));
}
}
public string PostNotification(PostNotificationParameters objPostNotificationParameters)
{
strnotificationDescription = @"SELECT NM.notificationText, NM.notificationType, NM.notificationDescription FROM " + _bucketRef.Name + " r use keys 'NotificationTypeMaster' " +
"unnest r.['notificationTypeMaster'] NM where NM.['roleCode'] = '" + objPostNotificationParameters.RoleCode + "' " +
"and NM.['deptCode'] = '" + objPostNotificationParameters.DeptCode + "' and NM.notificationType = " + objPostNotificationParameters.NotificationType + "";
var notificationDescriptionDocument = _bucket.Query <NotificationMessage>(strnotificationDescription).FirstOrDefault();
if (notificationDescriptionDocument != null)
{
string notificationText = string.Empty;
switch (notificationDescriptionDocument.NotificationType)
{
case (int)AspectEnums.NotificationType.IndividualCreation:
notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Status);
break;
case (int)AspectEnums.NotificationType.VehicleRegistration:
notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Value, objPostNotificationParameters.Status);
break;
case (int)AspectEnums.NotificationType.PermitRequest:
notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Value, objPostNotificationParameters.Status);
break;
case (int)AspectEnums.NotificationType.CompanyRegistration:
notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Value, objPostNotificationParameters.Status);
break;
case (int)AspectEnums.NotificationType.FineRequest:
notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Value, objPostNotificationParameters.Status);
break;
}
var NotificationDoc = new Document <Notification>()
{
Id = "notification_" + DateTime.Now.Ticks.ToString(),
Content = new Notification
{
NotificationDescription = notificationDescriptionDocument.NotificationDescription,
NotificationType = objPostNotificationParameters.NotificationType,
RoleCode = objPostNotificationParameters.RoleCode,
DeptCode = objPostNotificationParameters.DeptCode,
UserCode = objPostNotificationParameters.UserCode,
//NotificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.RegistrationNumnber, objPostNotificationParameters.Status),
NotificationText = notificationText,
NotificationCreatedDate = DateTime.Now.ToString(),
ReadReceipt = false,
Validity = 24,
},
};
var NotificationResult = _bucket.Insert(NotificationDoc);
}
else
{
return("notification not configured for Dept Code " + objPostNotificationParameters.DeptCode + " and Role Code " + objPostNotificationParameters.RoleCode + "");
}
return("notification has been created");
}
// For testing purposes only!!!
public void ClearBucket()
{
var n1ql = $"delete from `{_bucket.Name}`";
var query = QueryRequest.Create(n1ql);
_bucket.Query <dynamic>(query);
}
public void Submitting_View_Query_To_Ephemeral_Bucket_Fails()
{
var viewQuery = _bucket.CreateQuery("designDoc", "viewName");
var result = _bucket.Query <dynamic>(viewQuery);
Assert.IsFalse(result.Success);
Assert.AreEqual(result.Error, ExceptionUtil.EphemeralBucketViewQueries);
}
public void GetEvents(string actorName, int eventIndexStart, Action <object> callback)
{
var q =
$"SELECT b.* FROM `{_bucket.Name}` b WHERE b.actorName='{actorName}' AND b.eventIndex>={eventIndexStart} AND b.type='event' ORDER BY b.eventIndex ASC";
var req = QueryRequest.Create(q);
req.ScanConsistency(ScanConsistency.RequestPlus);
var res = _bucket.Query <Envelope>(req);
ThrowOnError(res);
var envelopes = res.Rows;
foreach (var envelope in envelopes)
{
callback(envelope.Event);
}
}
private void ProcessFlightRequest(string incomingMessage, string id)
{
// expecting messages that contain "{flight} from {airport} to {airport2}"
var matches = Regex.Matches(incomingMessage, "from (\\w+) to (\\w+)");
if (matches.Count < 1)
{
SendTextMessage("Sorry, I can't help you with those flights.", id);
return;
}
if (matches[0].Groups.Count != 3)
{
SendTextMessage("Sorry, I can't help you with those flights.", id);
return;
}
// uppercase the matches
var sourceairport = matches[0].Groups[1].Value.ToUpper();
var destinationairport = matches[0].Groups[2].Value.ToUpper();
var dayOfTheWeek = (int)DateTime.Now.DayOfWeek;
var n1ql = @"SELECT VALUE COUNT(*) FROM (
select r.sourceairport, r.destinationairport, a.name, s.flight, s.utc
from `travel-sample` r
unnest r.schedule s
inner join `travel-sample` a ON KEYS r.airlineid
where r.type = 'route'
and r.sourceairport = $sourceairport
and r.destinationairport = $destinationairport
and s.day = $dayOfTheWeek
order by s.utc
) flights;";
var query = QueryRequest.Create(n1ql);
query.AddNamedParameter("sourceairport", sourceairport);
query.AddNamedParameter("destinationairport", destinationairport);
query.AddNamedParameter("dayOfTheWeek", dayOfTheWeek);
var result = _bucket.Query <int>(query);
var count = result.Rows.First();
var resultMessage = $"There are {count} flights from {sourceairport} to {destinationairport} on {DateTime.Now.DayOfWeek.ToString()}";
SendTextMessage(resultMessage, id);
}
// end::SaveShoppingCart[]
public ShoppingCart GetCartByUserName(string userName)
{
var n1ql = $"SELECT c.* FROM `{_bucket.Name}` c WHERE c.userName = $UserName LIMIT 1";
var query = QueryRequest.Create(n1ql);
query.ScanConsistency(ScanConsistency.RequestPlus);
query.AddNamedParameter("UserName", userName);
return(_bucket.Query <ShoppingCart>(query).Rows.FirstOrDefault());
}
public ActionResult N1qlExample()
{
var query = QueryRequest.Create("SELECT b.foo, b.bar FROM `" + _bucket.Name + "` b");
query.ScanConsistency(ScanConsistency.RequestPlus);
var results = _bucket.Query <FooBar>(query).Rows;
return(View(results));
}
public IList <DataTracking> Get(string ip, string pageName)
{
var queryRequest = new QueryRequest()
.Statement("SELECT ip, pageName, browser, pageParameters FROM `ViajaNet` Where ip = $ip and pageName = $pageName")
.AddNamedParameter("$ip", ip)
.AddNamedParameter("$pageName", pageName);
return(_bucket.Query <DataTracking>(queryRequest)?.Rows);
}
public void Cleanup()
{
Console.WriteLine("Delete all users...");
var result = _bucket.Query <dynamic>("DELETE FROM `sqltocb` WHERE type='User';");
if (!result.Success)
{
Console.WriteLine($"{result.Exception?.Message}");
Console.WriteLine($"{result.Message}");
}
Console.WriteLine("Delete all updates...");
result = _bucket.Query <dynamic>("DELETE FROM `sqltocb` WHERE type='Update';");
if (!result.Success)
{
Console.WriteLine($"{result.Exception?.Message}");
Console.WriteLine($"{result.Message}");
}
}
static void BasicQuery(IBucket bucket)
{
var query = bucket.CreateQuery("beer", "brewery_beers").
Limit(5);
var result = bucket.Query<dynamic>(query);
foreach (var row in result.Rows)
{
Console.WriteLine(row);
}
}
