public ActionResult Delete(int id, FormCollection collection) { var db = new Models.Database1Entities(); Models.Clients client = db.Clients.Find(id); db.Clients.Remove(client); db.SaveChanges(); return(RedirectToAction("Index")); }
public JsonModel SaveProjectScheduler(ProjectScheduleViewModel model) { Models.Clients clientData = new Models.Clients(); clientData.ClientName = model.ClientName; clientData.City = model.City; clientData.State = model.State; clientData.ZipCode = model.ZipCode; clientData.AddressLine1 = model.Address1; clientData.AddressLine2 = model.Address2; context.Clients.Add(clientData); context.SaveChanges(); Models.ProjectNumbers obj = new Models.ProjectNumbers(); obj.ProjectManagerId = model.ProjectManagerId; obj.ProjectDeveloperId = model.ProjectDeveloperId; obj.NickName = model.NickName; obj.LocationId = model.LocationId; obj.AddressLine1 = model.Address1; obj.AddressLine2 = model.Address2; obj.ClientId = clientData.ClientId; obj.DateCreated = DateTime.Now; obj.DateModified = DateTime.Now; string TotalPNnumber = (context.ProjectNumbers.ToList().Count + 1).ToString(); obj.ProjectNumber = "PN0000" + TotalPNnumber; context.ProjectNumbers.Add(obj); context.SaveChanges(); foreach (var x in model.AddressDescriptors) { x.ProjectNumberId = obj.ProjectNumberId; x.AddressDescriptorId = 0; x.AddressDescriptorId = 0; } context.AddressDescriptors.AddRange(model.AddressDescriptors); context.SaveChanges(); Models.Projects objData = new Projects(); objData.Status = model.Status; objData.ProjectType = model.ProjectType; objData.DateModified = DateTime.Now; objData.DateCreated = DateTime.Now; //objData.EmployeeId = model.ResourceId; objData.ProjectNumberId = obj.ProjectNumberId; context.Projects.Add(objData); Models.ProjectRevisions objrevison = new Models.ProjectRevisions(); objrevison.ProjectManagerId = obj.ProjectManagerId; objrevison.ProjectDeveloperId = model.ProjectDeveloperId; objrevison.ProjectId = objData.ProjectId; objrevison.Hours = model.ProjectHours; objrevison.EmployeeId = model.ResourceId; objrevison.ProjectRevisionId = 1; context.ProjectRevisions.Add(objrevison); return(new JsonModel(null, "Save Successfully", (int)HttpStatusCode.OK, "")); }
public ActionResult Delete(int?id) { var db = new Models.Database1Entities(); Models.Clients client = db.Clients.Find(id); if (client == null) { return(HttpNotFound()); } return(View(client)); }
public ActionResult Edit([Bind(Include = "Id,name,surname,adress")] Models.Clients client) { var db = new Models.Database1Entities(); if (ModelState.IsValid) { db.Entry(client).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(client)); }
public async Task <ActionResult> Post(Clients _client) { var newclient = new Models.Clients() { BusinessName = _client.BusinessName, Shortname = _client.Shortname }; db.Clients.Add(newclient); await db.SaveChangesAsync(); return(new CreatedAtRouteResult("GetClient", new { id = _client.Id }, newclient)); }
public async Task <ActionResult> Put(Clients _client) { var newclient = new Models.Clients() { Id = _client.Id, BusinessName = _client.BusinessName, Shortname = _client.Shortname }; db.Entry(newclient).State = EntityState.Modified; await db.SaveChangesAsync(); return(NoContent()); }
public ActionResult Create(Models.Clients client) { var db = new Models.Database1Entities(); if (ModelState.IsValid) { db.Clients.Add(client); db.SaveChanges(); return(this.RedirectToAction("Index")); } return(this.View(client)); }
// GET: Clients public ActionResult Clients() { if (string.IsNullOrEmpty(RenderingContext.Current.Rendering.DataSource)) { return(Context.PageMode.IsExperienceEditor ? this.InfoMessage(new InfoMessage(DictionaryPhraseRepository.Current.Get("/Clients/No Datasource", "No Datasource assigned"), InfoMessage.MessageType.Warning)) : null); } var model = new Models.Clients() { ClientList = _clientsRepository.GetClientEntries(RenderingContext.Current.Rendering.Item) }; return(this.View("Clients", model)); }
public ActionResult Edit(int?id) { var db = new Models.Database1Entities(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Models.Clients client = db.Clients.Find(id); if (client == null) { return(HttpNotFound()); } return(View(client)); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Client = await _context.Clients.FirstOrDefaultAsync(m => m.Id == id); if (Client == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Client = await _context.Clients.FindAsync(id); if (Client != null) { _context.Clients.Remove(Client); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public ActionResult SaveCredentials(Models.Clients client) { if (ModelState.IsValid) { using (var context = new BPEntities()) { if (context.Clients.Any(x => x.NID.Equals(client.NID))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "You have already received a gift")); } client.Url = System.Web.HttpContext.Current.Request.Url.Host + "/" + Guid.NewGuid().ToString("N"); client.IsNew = true; context.Clients.Add(client); context.SaveChanges(); return(RedirectToAction("Index")); } } return(View("~/Views/Signup/Signup.cshtml", client)); }
public ActionResult Create(IFormCollection Dclients) { try { var newClients = new Models.Clients { Name = Dclients["Name"], Lastname = Dclients["Lastname"], PhoneNumber = Convert.ToInt32(Dclients["PhoneNumber"]), Description = Dclients["Description"] }; Singleton.Instance.ClientsList.Add(newClients); //Clistt.Add(newClients.Name); //IOrderedEnumerable<String> ListFC = Clistt.OrderBy(x => x.Length); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
//******************************************************************************************* //adding new submission protected void Button_Create_Submission_Click(object sender, EventArgs e) { try { ContentPlaceHolder placeholder = (ContentPlaceHolder)Page.Master.FindControl("ContentPlaceHolder1"); //ListView notes = (ListView)placeholder.FindControl("ListView_Consultant_Status"); //string statusMessage = "message not changed"; string recruiter, client, method, city, state, jobTitle, duration, vendor, vendorContact, clientSubmission, remarks, submissionStatus; DateTime date; Decimal rate; bool active; int sLNO, consultantId, recruiterID = 0, clientID, vendorID, vendorContactID; //get values entered by user using (var db = new ModelContext()) { sLNO = db.Submissions.Max(c => c.Slno) + 1; } consultantId = Int32.Parse(ConsultantId.Value); recruiter = cb_Recruiter.Text; client = cb_Client.Text; rate = Decimal.Parse(tb_Rate.Text); method = tb_Method.Text; city = tb_City.Text; state = cb_State.SelectedValue; jobTitle = tb_Job_Title.Text; duration = tb_Duration.Text; vendor = cb_Vendor.Text; vendorContact = cb_Vendor_Contact.Text; clientSubmission = tb_Client_Submission.Text; remarks = tb_Remarks.Text; submissionStatus = cb_Submission_Status.Text; date = DateTime.Parse(tb_Date.Text); active = true; //dtbs connect string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/Users/joshh/OneDrive/Documents/Database2.accdb"; OleDbConnection con = new OleDbConnection(connectionString); con.Open(); //get all SLNO numbers ArrayList sLNONums = new ArrayList(); string selectSLNONumbersQuery = "SELECT [SLNO] FROM Submissions;"; OleDbCommand readCmd = new OleDbCommand(selectSLNONumbersQuery, con); OleDbDataReader reader = readCmd.ExecuteReader(); while (reader.Read()) { sLNONums.Add(reader["SLNO"].ToString()); } reader.Close(); //check if SLNO already taken if (sLNONums.Contains(sLNO)) { throw new ArgumentException("SLNO number already used for different submission."); } //check recruiter name exists and get recruiter id List <string> recruiterNames = new List <string>(); ArrayList recruiters = new ArrayList(); string selectRecruiterNamesQuery = "SELECT [ID], [Recruiter Name] FROM [ASR-RECRUITERS];"; readCmd = new OleDbCommand(selectRecruiterNamesQuery, con); reader = readCmd.ExecuteReader(); while (reader.Read()) { recruiterNames.Add(reader["Recruiter Name"].ToString()); recruiters.Add(new Recruiter(reader["ID"].ToString(), reader["Recruiter Name"].ToString())); } reader.Close(); //check if recruiter name already taken if (!recruiterNames.Contains(recruiter)) { throw new ArgumentException("Recruiter name does not exist. First click add new Recruiter."); } //get the rec id # foreach (Recruiter r in recruiters) { if (recruiter.Equals(r.name)) { recruiterID = Int32.Parse(r.id); continue; } } using (ModelContext db = new ModelContext()) { //get client id var clientDb = db.Clients.FirstOrDefault(c => c.ClientName == client); if (clientDb == null) { clientDb = new Models.Clients { ClientName = client }; db.Clients.Add(clientDb); db.SaveChanges(); LoggingUtility.appendToLog(String.Format("new client added '{0}'", client)); } clientID = clientDb.Id; //get vendor id var vendorDb = db.Vendors.FirstOrDefault(c => c.VendorCompanyName == vendor); if (vendorDb == null) { vendorDb = new Models.Vendors { VendorCompanyName = vendor }; db.Vendors.Add(vendorDb); db.SaveChanges(); LoggingUtility.appendToLog(String.Format("new vendor added '{0}'", vendor)); } vendorID = vendorDb.Id; //get vendor contact id var vendorContactDb = db.VendorContact.FirstOrDefault(c => c.RecruiterName == vendorContact); if (vendorContactDb == null) { vendorContactDb = new Models.VendorContact { RecruiterName = vendorContact }; db.VendorContact.Add(vendorContactDb); db.SaveChanges(); LoggingUtility.appendToLog(String.Format("new vendor contact added '{0}'", vendorContact)); } vendorContactID = vendorContactDb.Id; //create new submission var newSubmission = new Models.Submissions { Slno = sLNO, AsrRecruiterId = recruiterID, Date = date, ConsultantId = consultantId, JobTitle = jobTitle, City = city, State = state, Duration = duration, VendorId = vendorID, VendorContactId = vendorContactID, ClientId = clientID, RatePerHour = rate, Method = method, ClientSubmission = clientSubmission, Remarks = remarks, SubmissionStatus = submissionStatus, Active = active }; db.Submissions.Add(newSubmission); db.SaveChanges(); LoggingUtility.appendToLog(String.Format("new submission successfully created with SLNO # {0} to client {1}", newSubmission.Slno, newSubmission.Client)); } con.Close(); //showMessage(String.Format("New submission #{0} to {1} successfully created.", sLNO, client)); //refresh page Response.Redirect($"~/Pages/ViewAllSubmissions.aspx?Id={ConsultantId.Value}"); } catch (Exception ex) { //statusMessage = ex.Message; //showMessage(ex.Message); //LoggingUtility.appendToLog(ex.Message); //LoggingUtility.appendToLog(ex.StackTrace); handleException(ex, sender.ToString()); } LoggingUtility.writeMessage(); //Response.Write("<script>alert('" + statusMessage + "')</script>"); }
private void updateSubmission(int slnoNum) { using (ModelContext db = new ModelContext()) { var submissionDb = db.Submissions.FirstOrDefault(c => c.Slno == slnoNum); if (submissionDb == null) { throw new ArgumentException(String.Format("Submission for SLNO #{0} cannot be found", slnoNum)); } //get fields string recruiter, client, rateString, method, city, state, jobTitle, duration, vendor, vendorContact, clientSubmission, remarks, status, dateString; bool active; recruiter = ComboBox_Recruiter.Text; client = ComboBox_Client.Text; rateString = TextBox_Rate.Text; method = TextBox_Method.Text; city = TextBox_City.Text; state = ComboBox_State.Text; jobTitle = TextBox_JobTitle.Text; duration = TextBox_Duration.Text; vendor = ComboBox_Vendor.Text; vendorContact = ComboBox_VendorContact.Text; clientSubmission = TextBox_ClientSubmission.Text; remarks = TextBox_Remarks.Text; status = ComboBox_SubmissionStatus.Text; dateString = Edit_TextBox_Date.Text; active = CheckBox_Active.Checked; //check fields FieldValidator.checkFields(recruiter, client, rateString, method, city, state, jobTitle, duration, vendor, vendorContact, clientSubmission, remarks, status, dateString); int rate = Int32.Parse(rateString); DateTime date = DateTime.Parse(dateString); //process submission changes //check if recruiter was changed, and then if recruiter doesn't exist, throw exception if (submissionDb.AsrRecruiterId == null || !db.AsrRecruiters.FirstOrDefault(c => c.Id == submissionDb.AsrRecruiterId).RecruiterName.Equals(recruiter)) { var recruiterDb = db.AsrRecruiters.FirstOrDefault(c => c.RecruiterName.Equals(recruiter)); if (recruiterDb == null) { throw new ArgumentException(String.Format("Recruiter Name '{0}' does not exist in database. Go to 'Add New Recruiter'", recruiter)); } else { submissionDb.AsrRecruiterId = recruiterDb.Id; } } //if client/vendor/vendorContact changed, and doesn't exist, first add to db if (submissionDb.ClientId == null || !db.Clients.FirstOrDefault(c => c.Id == submissionDb.ClientId).ClientName.Equals(client)) { var clientDb = db.Clients.FirstOrDefault(c => c.ClientName.Equals(client)); if (clientDb == null) { clientDb = new Models.Clients { ClientName = client }; db.Clients.Add(clientDb); db.SaveChanges(); LoggingUtility.appendToLog(String.Format("new client added '{0}'", client)); } submissionDb.ClientId = clientDb.Id; } if (submissionDb.VendorId == null || !db.Vendors.FirstOrDefault(c => c.Id == submissionDb.VendorId).VendorCompanyName.Equals(vendor)) { var vendorDb = db.Vendors.FirstOrDefault(c => c.VendorCompanyName.Equals(vendor)); if (vendorDb == null) { vendorDb = new Models.Vendors { VendorCompanyName = vendor }; db.Vendors.Add(vendorDb); db.SaveChanges(); LoggingUtility.appendToLog(String.Format("new vendor added '{0}'", vendor)); } submissionDb.VendorId = vendorDb.Id; } if (submissionDb.VendorContactId == null || !db.VendorContact.FirstOrDefault(c => c.Id == submissionDb.VendorContactId).RecruiterName.Equals(vendorContact)) { var vendorContactDb = db.VendorContact.FirstOrDefault(c => c.RecruiterName.Equals(vendorContact)); if (vendorContactDb == null) { vendorContactDb = new Models.VendorContact { RecruiterName = vendorContact }; db.VendorContact.Add(vendorContactDb); db.SaveChanges(); LoggingUtility.appendToLog($"new vendor contact added '{vendorContact}'"); } submissionDb.VendorContactId = vendorContactDb.Id; } var stateDb = db.UsStates.FirstOrDefault(c => c.Initials.Equals(state) || c.Ucname.Equals(state) || c.Lcname.Equals(state)); submissionDb.State = stateDb.Initials; submissionDb.RatePerHour = rate; submissionDb.Method = method; submissionDb.City = city; submissionDb.JobTitle = jobTitle; submissionDb.Duration = duration; submissionDb.ClientSubmission = clientSubmission; submissionDb.Remarks = remarks; submissionDb.SubmissionStatus = status; submissionDb.Date = date; submissionDb.Active = active; db.SaveChanges(); LoggingUtility.writeMessage(); } }