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())); } }