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 async Task <IHttpActionResult> Approved_DocIn(string id, DocIn model)
{
try
{
string query = @"select * from " + _bucket.Name + " where meta().id='" + id + "'";
var docInData = _bucket.Query <IndividualOutPut>(query).ToList();
if (docInData.Count == 0)
{
return(Content(HttpStatusCode.NotFound, MessageResponse.Message(HttpStatusCode.NotFound.ToString(), MessageDescriptions.NotFound, id), new JsonMediaTypeFormatter()));
}
/////////////////////////////////////////////////// Update Document Status Code
if (model.Status)
{
_bucket.Query <object>(@"Update " + _bucket.Name + " set status=true where meta().id='" + id + "'").ToList();
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Update, id + " status has been updated successfully."), new JsonMediaTypeFormatter()));
}
if (string.IsNullOrEmpty(model.RejReas))
{
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "193-Rejection reason is required."), new JsonMediaTypeFormatter()));
}
else
{
_bucket.Query <object>(@"Update " + _bucket.Name + " set rejReas='" + model.RejReas + "',status=false where meta().id='" + id + "'").ToList();
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Update, id + " status has been updated successfully."), new JsonMediaTypeFormatter()));
}
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public async Task<IHttpActionResult> RegisterCommonMasters([FromUri]string name, CommonMasters model)
{
try
{
if (!ModelState.IsValid)
{
var modelErrors = new List<string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter());
}
CommonMasters addNewCommonMaster = new CommonMasters();
addNewCommonMaster.Code = model.Code;
addNewCommonMaster.Value = model.Value;
addNewCommonMaster.Rank = model.Rank;
// add scoreCard code
string query = @"UPDATE " + _bucket.Name + " SET "+ name + " = ARRAY_APPEND("+ name + ", " + Newtonsoft.Json.JsonConvert.SerializeObject(addNewCommonMaster).ToString() + ") where meta().id='REF_EN_US'";
var result = _bucket.Query<object>(query);
return Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), "Master data has been added sucessfully"), new JsonMediaTypeFormatter());
}
catch (Exception ex)
{
return Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter());
}
}
public IHttpActionResult CompanyAddNumEmployee([FromUri] string id, NumEmployees model)
{
try
{
bool isThisNumEmployeeExist = false;
if (!ModelState.IsValid)
{
var modelErrors = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter()));
}
NumEmployees addNewNumEmployee = new NumEmployees();
addNewNumEmployee.Date = model.Date;
addNewNumEmployee.Employees = model.Employees;
// add NumEmployee code
string query = @"UPDATE " + _bucket.Name + " SET numEmployees = ARRAY_APPEND(numEmployees, " + Newtonsoft.Json.JsonConvert.SerializeObject(addNewNumEmployee).ToString() + ") where meta().id='" + id + "'";
var result = _bucket.Query <object>(query);
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), model.Employees + " has been added sucessfully"), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public IHttpActionResult SaveNotificationRoleWiseUserWise(Notification notificationObj)
{
try
{
var NotificationDoc = new Document <Notification>()
{
Id = "notification_" + DateTime.Now.Ticks.ToString(),
Content = new Notification
{
NotificationDescription = notificationObj.NotificationDescription,
NotificationType = notificationObj.NotificationType,
RoleCode = notificationObj.RoleCode,
DeptCode = notificationObj.DeptCode,
UserCode = notificationObj.UserCode,
NotificationText = notificationObj.NotificationText,
NotificationCreatedDate = DateTime.Now.ToString(),
ReadReceipt = false,
Validity = notificationObj.Validity,
},
};
var result = _bucket.Insert(NotificationDoc);
if (!result.Success)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), result.Message), new JsonMediaTypeFormatter()));
}
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, result.Document.Id), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public IHttpActionResult CompanyAddRole([FromUri] string id, Roles model)
{
try
{
bool isThisRoleExist = false;
if (!ModelState.IsValid)
{
var modelErrors = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter()));
}
Roles addNewRole = new Roles();
addNewRole.RoleID = model.RoleID;
addNewRole.Name = model.Name;
/////////////////// Validate Code for Role already exist or not.
var roleDoc = _bucket.Query <object>(@"SELECT roles From " + _bucket.Name + " where meta().id = '" + id + "'").ToList();
foreach (var item1 in roleDoc)
{
if (((Newtonsoft.Json.Linq.JToken)item1).Root["roles"] != null)
{
//roles-roleID
var roleIsExist = ((Newtonsoft.Json.Linq.JToken)item1).Root["roles"];
foreach (var itemTD in roleIsExist)
{
if (itemTD["RoleID"].ToString() == model.RoleID)
{
isThisRoleExist = true;
}
}
}
}
if (isThisRoleExist == true)
{
// role already exist.
return(Content(HttpStatusCode.Conflict, MessageResponse.Message(HttpStatusCode.Conflict.ToString(), model.RoleID + " already exists"), new JsonMediaTypeFormatter()));
}
else
{
// add role code
string query = @"UPDATE " + _bucket.Name + " SET roles = ARRAY_APPEND(roles, " + Newtonsoft.Json.JsonConvert.SerializeObject(addNewRole).ToString() + ") where meta().id='" + id + "'";
var result = _bucket.Query <object>(query);
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), model.RoleID + " has been added sucessfully"), new JsonMediaTypeFormatter()));
}
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public IHttpActionResult EncryptDecryptString(string value, int type)
{
try
{
string errorMsg = "Internal server error";
if (string.IsNullOrEmpty(value))
{
errorMsg = "Value is blank or empty";
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), errorMsg), new JsonMediaTypeFormatter()));
}
else if (type >= 3 || type <= 0)
{
errorMsg = "Invalid type";
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), errorMsg), new JsonMediaTypeFormatter()));
}
else
{
switch (type)
{
case 1:
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, EncryptDecrypt.Encryptword(value)), new JsonMediaTypeFormatter()));
case 2:
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, EncryptDecrypt.Decryptword(value)), new JsonMediaTypeFormatter()));
}
}
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), errorMsg), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> UpdateAboutUs([FromUri] string id, AboutUs model)
{
try
{
if (!ModelState.IsValid)
{
var modelErrors = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter()));
}
// add document code
string query = @"UPDATE " + _bucket.Name + " SET contents = '" + model.Contents + "',modify_On= '" + DataConversion.ConvertYMDHMS(DateTime.Now.ToString()) + "' where meta().id='" + id + "'";
var result = _bucket.Query <object>(query);
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), id + " has been updated sucessfully"), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> RegisterPassengerMessage(PassengerMessageModel model)
{
//Modified by Vishal on 23-07-2018 as per joe email
if (string.IsNullOrEmpty(model.NameEN) && string.IsNullOrEmpty(model.NameAR))
{
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "110-NameEN or NameAR is required"), new JsonMediaTypeFormatter()));
}
try
{
//Modified by Vishal on 24-07-2018 as per joe email
if (string.IsNullOrEmpty(model.NameEN) && string.IsNullOrEmpty(model.NameAR))
{
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "110-Either nameEN or nameAR is required"), new JsonMediaTypeFormatter()));
}
if (!ModelState.IsValid)
{
var modelErrors = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter()));
}
var userKey = "PassengerMessage_" + model.EmailAddress;
if (await _bucket.ExistsAsync(userKey))
{
return(Content(HttpStatusCode.Conflict, MessageResponse.Message(HttpStatusCode.Conflict.ToString(), "105-The e-mail already exists"), new JsonMediaTypeFormatter()));
}
// call third part api to check Vehicle is valid or not
var passengerMessageDoc = new Document <PassengerMessageModel>()
{
Id = userKey,
Content = new PassengerMessageModel
{
Action = "ADD",
PassengerID = userKey,
NameEN = model.NameEN,
NameAR = model.NameAR,
MobileNumber = model.MobileNumber,
EmailAddress = model.EmailAddress,
}
};
var result = await _bucket.InsertAsync(passengerMessageDoc);
if (!result.Success)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), result.Message), new JsonMediaTypeFormatter()));
}
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, result.Document.Id), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
/// <summary>
/// this function use for reset password
/// </summary>
/// <param name="model"></param>
/// <returns>reset password meesage</returns>
public IHttpActionResult ResetPassword(ResetPassword model)
{
if (string.IsNullOrEmpty(model.Email) && string.IsNullOrEmpty(model.MobileNo))
{
return(Content(HttpStatusCode.Conflict, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "177-Please select at laest one option for reset password"), new JsonMediaTypeFormatter()));
}
else
{
return(Content(HttpStatusCode.Conflict, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "177-Please select at laest one option for reset password"), new JsonMediaTypeFormatter()));
}
}
public IHttpActionResult DeleteDocOut(string id)
{
try
{
_bucket.Query <object>(@"Update " + _bucket.Name + " set status=false where meta().id='" + id + "' and status=true").ToList();
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Delete, id + " has been deleted successfully."), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> Performance(Performance model)
{
try
{
List <DriverScore> driverScoreList = new List <DriverScore>();
var strPath = @"G:\Projects\APTCAPI\CTAPI\Performance.json";
string localPath = new Uri(strPath).LocalPath;
Performance performance = new Performance();
using (StreamReader read = new StreamReader(strPath))
{
string json = read.ReadToEnd();
performance = JsonConvert.DeserializeObject <Performance>(json);
}
foreach (var score in performance.DriverScore)
{
DriverScore driverScore = new DriverScore();
driverScore.DriverId = score.DriverId;
driverScore.KmsTravelled = score.KmsTravelled;
driverScore.Braking = score.Braking;
driverScore.Accel = score.Accel;
driverScore.Corner = score.Corner;
driverScore.Idle = score.Idle;
driverScore.Speeding = score.Speeding;
driverScore.AverageTotal = score.Speeding;
driverScoreList.Add(score);
}
var performanceDoc = new Document <Performance>()
{
Id = CreateUserKey(),
Content = new Performance
{
//Id = CreateUserKey(),
StartDateTime = performance.StartDateTime,
EndDateTime = performance.EndDateTime,
Created_On = DataConversion.ConvertYMDHMS(DateTime.Now.ToString()),
DriverScore = driverScoreList
}
};
//IBucket _bucketperformance = ClusterHelper.GetBucket("DriverPerfoemance");
var result = await _bucket.InsertAsync(performanceDoc);
if (!result.Success)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), result.Message), new JsonMediaTypeFormatter()));
}
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, result.Document.Id), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> ApprovedVehicle(string id)
{
try
{
_bucket.Query <object>(@"Update " + _bucket.Name + " set status='AP' where meta().id='vehicle_" + id + "' and isActive=true").ToList();
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Update, id + " has been approved successfully"), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> RegisterIncidentMessage(IncidentMessageModel model)
{
try
{
if (!ModelState.IsValid)
{
var modelErrors = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter()));
}
var userKey = "IncidentMessage_" + model.DriverID + "_" + DateTime.Now.Ticks.ToString();
//if (await _bucket.ExistsAsync(userKey))
//{
// //return Content(HttpStatusCode.Conflict, new Error($"Incident Message '{model.DriverID}' already exists"));
// return Content(HttpStatusCode.Conflict, MessageResponse.Message(HttpStatusCode.Conflict.ToString(), "167-Driver ID already exists"), new JsonMediaTypeFormatter());
//}
// call third part api to check Vehicle is valid or not
var incidentMessageMessageDoc = new Document <IncidentMessageModel>()
{
Id = userKey,
Content = new IncidentMessageModel
{
DriverID = model.DriverID,
DateTime = model.DateTime,
Notes = model.Notes,
// this is only UAT testing for check when ct created.
Created_On = DataConversion.ConvertYMDHMS(DateTime.Now.ToString()),
Created_By = "CarTrack"
}
};
var result = await _bucket.InsertAsync(incidentMessageMessageDoc);
if (!result.Success)
{
//return Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), EncryptDecrypt.Encryptword(result.Message)), new JsonMediaTypeFormatter());
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), result.Message), new JsonMediaTypeFormatter()));
}
//return Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(),MessageDescriptions.Add, EncryptDecrypt.Encryptword(result.Document.Id)), new JsonMediaTypeFormatter());
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, result.Document.Id), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> Register(License model)
{
try
{
if (!ModelState.IsValid)
{
var modelErrors = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter()));
}
var licenseId = "License" + CreateUserKey(model.LicenseNumber);
if (await _bucket.ExistsAsync(model.LicenseNumber))
{
//return Content(HttpStatusCode.Conflict, new Error($"License:-'{model.LicenseNumber}' already exists"));
return(Content(HttpStatusCode.Conflict, MessageResponse.Message(HttpStatusCode.Conflict.ToString(), "License already exists"), new JsonMediaTypeFormatter()));
}
//call api check driver varification with EmiratiId if driver valid the driver valid will be true otherwise false
var licenseDoc = new Document <License>()
{
Id = licenseId,
Content = new License
{
Id = licenseId,
Action = "Add",
IssueDate = model.IssueDate,
ExpiryDate = model.ExpiryDate,
IsActive = true,
IsDeleted = true,
Created_On = DataConversion.ConvertYMDHMS(DateTime.Now.ToString()),
}
};
var result = await _bucket.InsertAsync(licenseDoc);
if (!result.Success)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), result.Message), new JsonMediaTypeFormatter()));
}
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, result.Document.Id), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public IHttpActionResult DeleteUser(string email)
{
try
{
query = @"update " + _bucket.Name + " set isActive=false where meta().id like 'login_%' and email='" + email + "'";
_bucket.Query <object>(query).ToList();
// query = @"update " + _bucket.Name + " set isActive=false where email='" + email + "'";
//_bucket.Query<object>(query).ToList();
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Delete, ""), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.Message), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> ApprovedIndividual(string notificationID)
{
string query = string.Empty;
try
{
query = @"Update " + _bucket.Name + " set readReceipt=true where meta().id like 'notification_%' and meta().id='" + notificationID + "'";
_bucket.Query <object>(query).ToList();
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Update, notificationID + " has been approved successfully"), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public IHttpActionResult GetDepartments(string id)
{
try
{
List <string> lstRole = new List <string>();
string Query = @"SELECT APTCREF.`Dept`.`" + id + "` From APTCREF where meta().id='Departments'";
var userDocument = _bucket.Query <object>(Query).ToList();
JObject jsonObj = JObject.Parse(userDocument[0].ToString());
return(Content(HttpStatusCode.OK, jsonObj));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public IHttpActionResult DeleteEmployee(string email)
{
string query = string.Empty;
try
{
query = @"Update " + _bucket.Name + " set isActive=false where meta().id like 'individual_%' and email='" + email + "'";
_bucket.Query <object>(query).ToList();
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Delete, ""), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
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()));
}
}
public async Task <IHttpActionResult> RegisterDriverStatus(DriverStatus model)
{
try
{
if (!ModelState.IsValid)
{
var modelErrors = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter()));
}
var userKey = "DriverStatus_" + model.VehicleID;
if (await _bucket.ExistsAsync(userKey))
{
//return Content(HttpStatusCode.Conflict, new Error($"Driver Status '{model.VehicleID}' already exists"));
return(Content(HttpStatusCode.Conflict, MessageResponse.Message(HttpStatusCode.Conflict.ToString(), "166-Vehicle ID already exists"), new JsonMediaTypeFormatter()));
}
// call third part api to check Vehicle is valid or not
var driverStatusMessageDoc = new Document <DriverStatus>()
{
Id = userKey,
Content = new DriverStatus
{
DriverID = userKey,
DriverState = model.DriverState,
Date = model.Date,
Time = model.Time,
VehicleID = model.VehicleID,
}
};
var result = await _bucket.InsertAsync(driverStatusMessageDoc);
if (!result.Success)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), result.Message), new JsonMediaTypeFormatter()));
}
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, result.Document.Id), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public IHttpActionResult GetPlateNumber(string id)
{
string strQuery = @"SELECT vehPlate.plateNumber From " + _bucket.Name + " where meta().id like '%vehicle%' and isActive=true and keyID='" + id + "'";
var allVehicleDocument = _bucket.Query <VehPlateOutPut>(strQuery).FirstOrDefault();
if (allVehicleDocument == null)
{
return(Content(HttpStatusCode.NotFound, MessageResponse.Message(HttpStatusCode.NotFound.ToString(), MessageDescriptions.NotFound, id), new JsonMediaTypeFormatter()));
}
else
{
return(Content(HttpStatusCode.OK, allVehicleDocument));
}
//
}
public IHttpActionResult CompanyAddActivitie([FromUri] string id, Activities model)
{
try
{
Activities addNewActivitie = new Activities();
addNewActivitie.ActivityID = model.ActivityID;
// add Activitie code
string query = @"UPDATE " + _bucket.Name + " SET activities = ARRAY_APPEND(activities, " + Newtonsoft.Json.JsonConvert.SerializeObject(addNewActivitie).ToString() + ") where meta().id='" + id + "'";
var result = _bucket.Query <object>(query);
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), model.ActivityID + " has been added sucessfully"), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public IHttpActionResult MatchIcaOtp(MatchOtp model)
{
try
{
string otpDocId = "otp_" + model.Id;
string query = @"SELECT * From " + _bucket.Name + " as APTCCRM where meta().id= '" + otpDocId + "'";
//string otpDocId = "otp_" + model.Id.Split('_')[1].ToString();
var userOtp = _bucket.Query <object>(query).ToList();
if (userOtp.Count > 0)
{
JObject jsonObj = JObject.Parse(userOtp[0].ToString());
string otp = (string)jsonObj["APTCCRM"]["mobileOtp"];
//if (otp == model.otp)
//{
_bucket.Remove(otpDocId);
if (model.IsIca == true)
{
query = @"SELECT * From ICADB as userDetails where emailId= '" + model.Id + "'";
var userDocument = _bucket.Query <object>(query);
return(Content(HttpStatusCode.OK, ((Couchbase.N1QL.QueryResult <object>)userDocument).Rows[0]));
}
else
{
if (model.DocType != "individual")
{
query = @"SELECT * From " + _bucket.Name + " as userDetails where meta().id like'login_%' and email='" + model.Id + "'";
}
else
{
query = @"SELECT * From " + _bucket.Name + " as userDetails where meta().id like'login_%' and email='" + model.Id + "' and docType='individual'";
}
var userDocument = _bucket.Query <object>(query);
return(Content(HttpStatusCode.OK, ((Couchbase.N1QL.QueryResult <object>)userDocument).Rows[0]));
}
}
else
{
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "173-invalid otp"), new JsonMediaTypeFormatter()));
}
}
catch (Exception ex)
{
return(Content(HttpStatusCode.Forbidden, MessageResponse.Message(HttpStatusCode.Forbidden.ToString(), ex.Message), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> Delete(string id)
{
try
{
var result = await _bucket.RemoveAsync(id);
if (!result.Success)
{
return(Content(HttpStatusCode.Conflict, MessageResponse.Message(HttpStatusCode.Conflict.ToString(), "Data has not been updated."), new JsonMediaTypeFormatter()));
}
return(Content(HttpStatusCode.Accepted, "deleted"));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.Forbidden, ex.StackTrace));
}
}
public IHttpActionResult GetAllFnctn()
{
try
{
var docInDocument = _bucket.Query <object>(@"SELECT * From " + _bucket.Name + " as Fnctn where meta().id like 'fnctn_%'").ToList();
if (docInDocument.Count == 0)
{
return(Content(HttpStatusCode.NoContent, "182-please enter valid function id."));
}
else
{
return(Content(HttpStatusCode.OK, docInDocument));
}
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> updateAPTCVehicle(Vehicle_CT_Data model)
{
//string CTDriverUpdateAPI = ConfigurationManager.AppSettings.Get("CTDriverUpdateAPI");
string CTUpdateAPIURL = ConfigurationManager.AppSettings.Get("CTVehicleUpdateURL");
string CTAPIUserId = ConfigurationManager.AppSettings.Get("CTAPIUserId");
string CTAPIPassword = ConfigurationManager.AppSettings.Get("CTAPIPassword");
try
{
using (var client = new HttpClient())
{
using (var request = new HttpRequestMessage(HttpMethod.Post, CTUpdateAPIURL))
{
var byteArray = Encoding.ASCII.GetBytes(CTAPIUserId + ":" + CTAPIPassword);
client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Basic", Convert.ToBase64String(byteArray));
var jsonInpt = JsonConvert.SerializeObject(model);
var response = await client.PostAsync(CTUpdateAPIURL, new StringContent(jsonInpt));
response.EnsureSuccessStatusCode();
string content = await response.Content.ReadAsStringAsync();
JObject json = JObject.Parse(content);
if (response.StatusCode == HttpStatusCode.OK)
{
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), content, ""), new JsonMediaTypeFormatter()));
}
else
{
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), ""), new JsonMediaTypeFormatter()));
}
}
}
}
catch (Exception ex)
{
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), ex.InnerException.Message.ToString()), new JsonMediaTypeFormatter()));
}
}
public async Task <IHttpActionResult> Delete(string id)
{
try
{
bool isDeleted = true;
string queryString = @" update " + _bucket.Name + " set isDeleted=" + isDeleted + " where id= '" + id + "'";
var result = await _bucket.QueryAsync <DriverModel>(queryString);
if (!result.Success)
{
return(Content(HttpStatusCode.Conflict, MessageResponse.Message(HttpStatusCode.Conflict.ToString(), "Data has not been updated."), new JsonMediaTypeFormatter()));
}
return(Content(HttpStatusCode.Accepted, "record deleted successfully"));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.Forbidden, new Error(ex.StackTrace)));
}
}
public async Task<IHttpActionResult> UpdateCommonMasters([FromUri]string name, CommonMasters model)
{
try
{
if (!ModelState.IsValid)
{
var modelErrors = new List<string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter());
}
string query = @"SELECT Contents." + name + " From " + _bucket.Name + " as CommonMasters where meta().id='REF_EN_US'";
var CommonMasterDocument = _bucket.Query<object>(query).ToList();
foreach (var item1 in CommonMasterDocument)
{
var cMData = ((Newtonsoft.Json.Linq.JToken)item1).Root[""+ name +""];
foreach (var item in cMData)
{
if (item["Code"].ToString()==model.Code)
{
// edit Common Master
string updateQuery = @"UPDATE " + _bucket.Name + " SET value = '" + model.Value + "',rank = '" + model.Rank + "' where meta().id='REF_EN_US'";
var result = _bucket.Query<object>(updateQuery);
return Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), name + " has been updated sucessfully"), new JsonMediaTypeFormatter());
}
}
}
return Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "code not found."), new JsonMediaTypeFormatter());
}
catch (Exception ex)
{
return Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter());
}
}
public IHttpActionResult IndividualAddDriverStatus([FromUri] string id, DriverStatus model)
{
try
{
bool isThisIncidentExist = false;
if (!ModelState.IsValid)
{
var modelErrors = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
modelErrors.Add(modelError.ErrorMessage);
}
}
return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter()));
}
DriverStatus addNewDriverStatus = new DriverStatus();
addNewDriverStatus.DriverID = model.DriverID;
addNewDriverStatus.DriverState = model.DriverState;
addNewDriverStatus.Date = model.Date;
addNewDriverStatus.Time = model.Time;
addNewDriverStatus.VehicleID = model.VehicleID;
/////////////////// Validate Code for incident already exist or not.
var incidentDoc = _bucket.Query <object>(@"SELECT incidents From " + _bucket.Name + " where meta().id = '" + id + "'").ToList();
// add driver status
string query = @"UPDATE " + _bucket.Name + " SET driverStatus = ARRAY_APPEND(driverStatus, " + Newtonsoft.Json.JsonConvert.SerializeObject(addNewDriverStatus).ToString() + ") where meta().id='" + id + "'";
var result = _bucket.Query <object>(query);
return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), model.DriverID + "driver status has been added sucessfully"), new JsonMediaTypeFormatter()));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter()));
}
}
