public ResponseDomainModel ReportedIssueFeedBack(ReportIssueDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var res = objHelper.Query <string>("ReportedIssueFeedBack", new { issueid = model.ReportId, speedofsolution = model.SpeedOfSolution, Communication = model.Communication, quality = model.Quality, availability = model.Availability }).FirstOrDefault(); if (res != null && res == "Update") { objRes.isSuccess = false; objRes.response = "Feedback saved successfully."; } else { objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } } catch (Exception ex) { ErrorLog.LogError(ex); objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } return(objRes); }
public ResponseDomainModel AddProjectWorkingHoursBeforePms(ProjectWorkingHoursBeforePMSDomainModel model) { try { ResponseDomainModel objRes = new ResponseDomainModel(); var add = objHelper.Query <string>("ADD_PROJECT_WORKING_HOURS_BEFORE_PMS", new { projectid = model.ProjectId, Workinghours = model.WorkinghHours, createddate = model.CreatedDate, createdby = model.CreatedBy }).FirstOrDefault(); if (add == "Insert") { objRes.isSuccess = true; objRes.response = "Working Hours saved Successfully."; } else if (add == "Update") { objRes.isSuccess = true; objRes.response = "Working Hours updated Successfully."; } else { objRes.isSuccess = false; objRes.response = "Working Hours not saved."; } return(objRes); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public JsonResult AddDailyStatusReportByTeamLeader(EmployeeDailyReportModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); ViewBag.Class = "display-hide"; try { if (model != null) { model.WorkingHours = model.Hours + "." + model.Minutes; model.CreatedBy = UserManager.user.UserId; model.Filename = string.Empty; model.CreatedDate = DateTime.ParseExact(model.ReportDateStr, "dd/MM/yyyy", CultureInfo.InvariantCulture); var serialized = JsonConvert.SerializeObject(model); var client = new HttpClient(); var content = new StringContent(serialized, System.Text.Encoding.UTF8, "application/json"); client.BaseAddress = new Uri(HttpContext.Request.Url.AbsoluteUri); var result = client.PostAsync(BaseURL + "/api/EmployeeDailyStatusReport/AddUpdateEmployeeDailyReportByTeamLeader", content).Result; if (result.StatusCode == HttpStatusCode.OK) { var contents = result.Content.ReadAsStringAsync().Result; objRes = new JavaScriptSerializer().Deserialize <ResponseDomainModel>(contents); } } } catch (Exception ex) { ErrorLog.LogError(ex); } return(Json(objRes)); }
public ResponseDomainModel UpdateProfile(UpdateUpworkProfileDomainModel model) { ResponseDomainModel resp = new ResponseDomainModel(); try { var response = objHelper.Query <ResponseDomainModel>("UpdateProfile", new { ProfileId = model.ProfileId, ProfileName = model.ProfileName, ProjectTypeId = model.ProjectTypeId, hourlyRate = model.hourlyRate, loggedHours = model.loggedHours, amount = model.amount, createdBy = model.createdBy }).First(); return(resp = response); } catch (SqlException sq) { ErrorLog.LogError(sq); resp.response = sq.Message; return(resp); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ResponseDomainModel UpdateClientArchive(long ClientId) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var res = objHelper.Query <string>("UpdateClientArchive", new { clientid = ClientId }); string Archived = res.First(); if (Archived == "Insert") { objRes.isSuccess = true; objRes.response = "Client has Archived."; } else if (Archived == "Update") { objRes.isSuccess = true; objRes.response = "Client has removed from Archive."; } } catch (Exception ex) { ErrorLog.LogError(ex); } return(objRes); }
public HttpResponseMessage AddUpdateClient(ClientDomainModel model) { try { HttpResponseMessage httpResponse = new HttpResponseMessage(); ResponseDomainModel res = new ResponseDomainModel(); if (model != null) { res = ClientRepository.AddUpdateClient(model); if (res != null && res.isSuccess) { httpResponse = Request.CreateResponse(HttpStatusCode.OK, res); } else { httpResponse = Request.CreateResponse(HttpStatusCode.Unauthorized, res); } } return(httpResponse); } catch (Exception ex) { ErrorLog.LogError(ex); throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent("An error occurred, please try again or contact the administrator."), ReasonPhrase = "An error occurred, please try again or contact the administrator.", StatusCode = HttpStatusCode.InternalServerError }); } }
public HttpResponseMessage AddUpdateEmployeeDailyReportByTeamLeader(EmployeeDailyReportDomainModel model) { HttpResponseMessage httpResponse = new HttpResponseMessage(); ResponseDomainModel response = new ResponseDomainModel(); try { response = employeeDailyStatusReportRepository.AddDailyStatusReportByTeamLeader(model); if (response == null) { response.isSuccess = false; httpResponse = Request.CreateResponse(HttpStatusCode.InternalServerError, "Error Occurred"); } else if (response.isSuccess == true) { httpResponse = Request.CreateResponse(HttpStatusCode.OK, response); } else { response.isSuccess = false; httpResponse = Request.CreateResponse(HttpStatusCode.NotImplemented, response); } return(httpResponse); } catch (Exception ex) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent("An error occurred, please try again or contact the administrator."), ReasonPhrase = "An error occurred, please try again or contact the administrator.", StatusCode = HttpStatusCode.InternalServerError }); } }
public ResponseDomainModel MergeProject(long projectmergeto, long projectmergefrom) { try { ResponseDomainModel objRes = new ResponseDomainModel(); var merge = objHelper.Query <string>("MERGEPROJECT", new { projectmergeto = projectmergeto, projectmergefrom = projectmergefrom }).FirstOrDefault(); var add = objHelper.Query <string>("ADD_MERGE_PROJECT_DETAILS", new { projectmergeto = projectmergeto, projectmergefrom = projectmergefrom }).FirstOrDefault(); if (merge == "Successfull" && add == "Insert") { objRes.isSuccess = true; objRes.response = "Project Merged Successfully."; } else { objRes.isSuccess = false; objRes.response = "something wrong with database"; } return(objRes); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ResponseDomainModel AddUpdateClient(ClientDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { int ClientId = objHelper.ExecuteScalar("AddUpdateClient", new { ClientId = model.ClientId, FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Skype = model.Skype, Whatsapp = model.Whatsapp, PhoneNumber = model.PhoneNumber, SourceId = model.SourceId, BussinessName = model.BussinessName, Website = model.Website, Location = model.Location, City = model.City, State = model.State, CountryId = model.CountryId, ZipCode = model.ZipCode, GSTNumber = model.GSTNumber, PanNumber = model.PanNumber, PaypalId = model.PaypalId, Remarks = model.Remarks, LinkedInUrl = model.LinkedInUrl, FacebookUrl = model.FacebookUrl, TwitterUrl = model.TwitterUrl, IsActive = true, CreatedDate = DateTime.Now, Archived = model.Archived, CreatedBy = model.CreatedBy }); if (model.ClientId > 0) { objRes.isSuccess = true; objRes.response = "Client updated successfully."; } else if (ClientId > 0) { objRes.isSuccess = true; objRes.response = "Client added successfully."; } else { objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } } catch (Exception ex) { ErrorLog.LogError(ex); objRes.isSuccess = false; objRes.response = ex.Message; } return(objRes); }
public ResponseDomainModel AddUpdateEmployeeDailyReport(AddEmployeeDailyStatusReportDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { if (model != null && model.listEmployeeDailyStatusReport != null && model.listEmployeeDailyStatusReport.Count > 0) { foreach (EmployeeDailyReportDomainModel obj in model.listEmployeeDailyStatusReport) { if (obj.ProjectId > 0) { var add = objHelper.Query <string>("AddUpdateEmployeeDailyReport", new { DailyReportId = obj.DailyReportId, EmployeeId = obj.EmployeeId, ReportDate = DateTime.Now, ProjectId = obj.ProjectId, ReportCategoryId = obj.ReportCategoryId, Description = obj.Description, WorkingHours = obj.WorkingHours, Filename = obj.Filename, IsActive = true, CreatedDate = DateTime.Now, CreatedBy = obj.CreatedBy, IsByTeamLeader = false }).FirstOrDefault(); if (add == "Insert") { objRes.isSuccess = true; objRes.response = "Status Report Saved Successfully."; } else if (add == "Update") { objRes.isSuccess = true; objRes.response = "Status Report Updated Successfully."; } else { objRes.isSuccess = false; objRes.response = "Status Report not saved."; } } } } return(objRes); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ResponseDomainModel AddUpdateBug(BugsDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var res = objHelper.Query <string>("AddUpdateBug", new { bugid = model.BugId, userid = model.UserId, bugreportedby = model.BugReportedBy, projectid = model.ProjectId, subject = model.BugSubject, description = model.BugDescription, file = model.Files, priority = model.Priority, status = model.Status }).FirstOrDefault(); if (string.IsNullOrWhiteSpace(res)) { objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } else if (res == "Insert") { objRes.isSuccess = true; objRes.response = "Bug added successfully."; } else if (res == "Update") { objRes.isSuccess = true; objRes.response = "Bug updated successfully."; } else if (res == "Change") { objRes.isSuccess = false; objRes.response = "Not a valid Request."; } else { objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } } catch (Exception ex) { ErrorLog.LogError(ex); objRes.isSuccess = false; objRes.response = ex.Message; } return(objRes); }
public string UpdateBugFiles(BugFilesDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var res = objHelper.Query <string>("UpdateBugFiles", new { bugid = model.BugId, files = model.Files }).FirstOrDefault(); return(res); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ActionResult ArchiveClient(long ClientId, bool Archived = false) { ResponseDomainModel objRes = new ResponseDomainModel(); var client = new HttpClient(); client.BaseAddress = new Uri(HttpContext.Request.Url.AbsoluteUri); var result = client.GetAsync(BaseURL + "/api/Client/UpdateClientArchive?ClientId=" + ClientId).Result; if (result.StatusCode == HttpStatusCode.OK) { var contents = result.Content.ReadAsStringAsync().Result; var Response = new JavaScriptSerializer().Deserialize <ResponseDomainModel>(contents); objRes = Response; } return(RedirectToAction("_Clients", new { Archived = Archived })); }
public ResponseDomainModel AddUpdateClient(ClientDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { int ClientId = objHelper.ExecuteScalar("AddUpdateClient", new { ClientId = model.ClientId, FirstName = model.FirstName, LastName = model.LastName, Location = model.Location, TimeZone = model.TimeZone, Email = model.Email, Skype = model.Skype, Whatsapp = model.Whatsapp, PhoneNumber = model.PhoneNumber, IsActive = true, CreatedDate = DateTime.Now, Archived = model.Archived, CreatedBy = model.CreatedBy }); if (model.ClientId > 0) { objRes.isSuccess = true; objRes.response = "Client updated successfully."; } else if (ClientId > 0) { objRes.isSuccess = true; objRes.response = "Client added successfully."; } else { objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } } catch (Exception ex) { ErrorLog.LogError(ex); objRes.isSuccess = false; objRes.response = ex.Message; } return(objRes); }
public ResponseDomainModel AddUpdateProject(AddUpdateProjectDomainModel model) { ResponseDomainModel resp = new ResponseDomainModel(); try { var response = objHelper.Query <ResponseDomainModel>("AddUpdateProjectAndEstimation", new { ProjectId = model.ProjectId, ClientId = model.ClientId, ProjectTypeId = model.ProjectTypeId, ProjectTitle = model.ProjectTitle, UploadDetailsDocument = model.UploadDetailsDocument, StartDate = model.StartDate, EndDate = model.EndDate, ProjectUrl = model.ProjectUrl, ProjectStatus = model.ProjectStatus, Archived = model.Archived, CreatedBy = model.CreatedBy, EstimateHours = model.EstimateHours.ToString(), AssignHours = model.AssignedHours.ToString(), UploadDocument = model.UploadDocument, DeveloperCodingHours = model.developerCodinghours.ToString(), WebServiceHours = model.WebserviceHours.ToString(), DesignHours = model.EstimateDesignHours.ToString(), QAHours = model.QualityAnalystHours.ToString(), HourlyRate = model.HourlyRate, FixedPrice = model.FixedPrice, CreatedDate = DateTime.Now }).First(); return(response); } catch (SqlException sq) { ErrorLog.LogError(sq); resp.response = sq.Message; return(resp); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ResponseDomainModel AddUpdateFeedback(FeedbackDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { int FeedbackId = objHelper.ExecuteScalar("AddUpdateFeedback", new { FeedbackId = model.FeedbackId, ProjectId = model.ProjectId, UserId = model.UserId, FeedTypeId = model.FeedTypeId, Name = model.Name, Description = model.Description, Feed = model.Feed, IsActive = model.IsActive, CreatedDate = DateTime.Now, IsDeleted = false }); if (model.FeedbackId > 0) { objRes.isSuccess = true; objRes.response = "Feedback updated successfully."; } else if (FeedbackId > 0) { objRes.isSuccess = true; objRes.response = "Feedback added successfully."; } else { objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } } catch (Exception ex) { ErrorLog.LogError(ex); objRes.isSuccess = false; objRes.response = ex.Message; } return(objRes); }
public ResponseDomainModel DeleteFeedback(long FeedbackId) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var res = objHelper.Execute("DeleteFeedback", new { FeedbackId = FeedbackId }); if (res > 0) { objRes.isSuccess = true; objRes.response = "sucsess"; } } catch (Exception ex) { ErrorLog.LogError(ex); } return(objRes); }
public ResponseDomainModel ChangePassword(ChangePassword model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var user = objHelper.Query <UserDetailsDomainModel>("GetEmployeeDataById", new { UserId = model.UserId }).FirstOrDefault(); if (user != null && user.UserId > 0) { if (user.Password == model.OldPassword) { int res = objHelper.Execute("UpdateUserPassword", new { UserId = model.UserId, Password = model.NewPassword }); if (res > 0) { objRes.response = "Password changed successfully."; objRes.isSuccess = true; } else { objRes.response = "Something went wrong, Please try again."; objRes.isSuccess = false; } } else { objRes.response = "You have entered incorrect current password."; objRes.isSuccess = false; } } else { objRes.response = "User does not exist."; objRes.isSuccess = false; } } catch (Exception ex) { ErrorLog.LogError(ex); objRes.response = "Something went wrong, Please try again."; objRes.isSuccess = false; } return(objRes); }
public ResponseDomainModel ActivateDeactivateClient(long ClientId, bool IsActive) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var res = objHelper.Execute("ActivateDeactivateClient", new { ClientId = ClientId, IsActive = IsActive }); if (res > 0) { objRes.isSuccess = true; objRes.response = "sucsess"; } } catch (Exception ex) { ErrorLog.LogError(ex); } return(objRes); }
public ResponseDomainModel DeleteProjectReportCategory(long CategoryId) { try { ResponseDomainModel objRes = new ResponseDomainModel(); var res = objHelper.Execute("DeleteProjectReportCategory", new { CategoryId = CategoryId }); if (res > 0) { objRes.isSuccess = true; objRes.response = "success"; } return(objRes); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ResponseDomainModel ActivateDeactivateProjectReportCategory(long CategoryId, bool IsActive) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var res = objHelper.Execute("ActivateDeactivateProjectReportCategory", new { CategoryId = CategoryId, IsActive = IsActive }); if (res > 0) { objRes.isSuccess = true; objRes.response = "success"; } return(objRes); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ResponseDomainModel UpdateProjectStatus(UpdateProjectStatusDomainModel model) { ResponseDomainModel responseModel = new ResponseDomainModel(); try { var response = objHelper.Execute("UpdateProjectStatus", new { ProjectId = model.ProjectId, status = model.status, ProjectUrl = model.ProjectUrl }); if (response > 0) { responseModel.isSuccess = true; responseModel.response = "Success"; } return(responseModel); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ActionResult AddUpdateReportIssue(ReportIssueDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); if (model != null) { model.UserId = UserManager.user.UserId; var serialized = JsonConvert.SerializeObject(model); var client = new HttpClient(); var content = new StringContent(serialized, System.Text.Encoding.UTF8, "application/json"); client.BaseAddress = new Uri(HttpContext.Request.Url.AbsoluteUri); var result = client.PostAsync(BaseURL + "/api/NetworkIssues/AddUpdateReportIssue", content).Result; if (result.StatusCode == HttpStatusCode.OK) { var contents = result.Content.ReadAsStringAsync().Result; var Response = JsonConvert.DeserializeObject <ResponseDomainModel>(contents); objRes = Response; } } return(RedirectToAction("_ReportIssue")); }
public ResponseDomainModel AddUpdateReportIssue(ReportIssueDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var res = objHelper.Query <string>("AddUpdateReportIssue", new { reportid = model.ReportId, userid = model.UserId, isuuesubject = model.IssueSubject, issuedescription = model.IssueDescription, priority = model.Priority, remark = model.Remark, status = model.Status }).FirstOrDefault(); if (res == "Insert") { objRes.isSuccess = true; objRes.response = "Issue added successfully"; } else if (res == "Update") { objRes.isSuccess = true; objRes.response = "Issue updated successfully."; } else { objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } } catch (Exception ex) { ErrorLog.LogError(ex); objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } return(objRes); }
public JsonResult AddEmployeeDailyStatusReport(AddEmployeeDailyReportModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); ViewBag.Class = "display-hide"; try { if (model.listEmployeeDailyStatusReport != null && model.listEmployeeDailyStatusReport.Count > 0) { foreach (var obj in model.listEmployeeDailyStatusReport) { if (obj.EmployeeId == 0) { obj.EmployeeId = UserManager.user.UserId; } obj.WorkingHours = obj.Hours + "." + obj.Minutes; obj.CreatedBy = UserManager.user.UserId; obj.Filename = string.Empty; } var serialized = JsonConvert.SerializeObject(model); var client = new HttpClient(); var content = new StringContent(serialized, System.Text.Encoding.UTF8, "application/json"); client.BaseAddress = new Uri(HttpContext.Request.Url.AbsoluteUri); var result = client.PostAsync(BaseURL + "/api/EmployeeDailyStatusReport/AddUpdateEmployeeDailyReport", content).Result; if (result.StatusCode == HttpStatusCode.OK) { var contents = result.Content.ReadAsStringAsync().Result; objRes = new JavaScriptSerializer().Deserialize <ResponseDomainModel>(contents); } } } catch (Exception ex) { //ModelState.AddModelError("CustomError", ex.Message); //ViewBag.Class = "alert-danger"; } return(Json(objRes)); }
public ResponseDomainModel AddUpdateReportCategory(ProjectReportCategoryDomainModel model) { ResponseDomainModel objRes = new ResponseDomainModel(); try { var CategoryId = objHelper.ExecuteScalar("AddUpdateReportCategory", new { CategoryId = model.CategoryId, DepartmentId = model.DepartmentId, CategoryName = model.CategoryName, IsActive = model.IsActive, CreatedDate = model.CreatedDate, CreatedBy = model.CreatedBy }); if (model.CategoryId > 0) { objRes.isSuccess = true; objRes.response = "Category updated successfully."; } else if (CategoryId > 0) { objRes.isSuccess = true; objRes.response = "Category added successfully."; } else { objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } return(objRes); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ResponseDomainModel AddProjectTimeEstimation(AddendumDomainModel model) { try { ResponseDomainModel objRes = new ResponseDomainModel(); int ProjectTimeEstimation = objHelper.ExecuteScalar("AddProjectTimeEstimation", new { @ProjectId = model.ProjectId, EstimateHours = model.EstimateHours, AssignHours = model.AssignHours, UploadDocument = model.UploadDocument, DeveloperCodingHours = model.DeveloperCodingHours, WebServiceHours = model.WebServiceHours, DesignHours = model.DesignHours, QAHours = model.QAHours, IsApprove = model.IsApprove, HourlyRate = model.HourlyRate, CreatedDate = model.CreatedDate }); if (ProjectTimeEstimation > 0) { objRes.isSuccess = true; objRes.response = "Project Time Estimation saved successfully"; } else { objRes.isSuccess = false; objRes.response = "Something went wrong, please try again."; } return(objRes); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public HttpResponseMessage AddupdateDesignation(DesignationDomainModel model) { try { HttpResponseMessage httpResponse = new HttpResponseMessage(); ResponseDomainModel res = new ResponseDomainModel(); if (model != null && !string.IsNullOrWhiteSpace(model.DesignationName)) { res = managementRepository.AddUpdateDesignation(model); if (res != null && res.isSuccess) { httpResponse = Request.CreateResponse(HttpStatusCode.OK, res); } else { httpResponse = Request.CreateResponse(HttpStatusCode.Unauthorized, res); } } else { res.isSuccess = false; res.response = "Please enter designation name"; httpResponse = Request.CreateResponse(HttpStatusCode.Unauthorized, res); } return(httpResponse); } catch (Exception ex) { ErrorLog.LogError(ex); throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent("An error occurred, please try again or contact the administrator."), ReasonPhrase = "An error occurred, please try again or contact the administrator.", StatusCode = HttpStatusCode.InternalServerError }); } }