private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { var name = dataGridView1.CurrentCell.ColumnIndex; switch (name) { case 0: if (dataGridView1.CurrentCell.Value != null && UpdateEntries.CheckMovie(title: dataGridView1.CurrentCell.Value.ToString())) { UpdateEntries.UpdateMoJson(orval, "Title", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); MessageBox.Show("Movie data updated succesfully"); } else { MessageBox.Show("Wrong movie info"); dataGridView1.CurrentCell.Value = orval; } break; case 1: if (dataGridView1.CurrentCell.Value != null && UpdateEntries.CheckMovie(genre: dataGridView1.CurrentCell.Value.ToString())) { UpdateEntries.UpdateMoJson(orval, "Genre", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); MessageBox.Show("Movie data updated succesfully"); } else { MessageBox.Show("Wrong movie info"); dataGridView1.CurrentCell.Value = orval; } break; case 2: if (UpdateEntries.CheckMovie(duration: dataGridView1.CurrentCell.Value.ToString())) { UpdateEntries.UpdateMoJson(orval, "Duration", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); MessageBox.Show("Movie data updated succesfully"); } else { MessageBox.Show("Wrong movie info"); dataGridView1.CurrentCell.Value = orval; } break; case 3: if (UpdateEntries.CheckMovie(price: dataGridView1.CurrentCell.Value.ToString())) { UpdateEntries.UpdateMoJson(orval, "Price", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); MessageBox.Show("Movie data updated succesfully"); } else { MessageBox.Show("Wrong movie info"); dataGridView1.CurrentCell.Value = orval; } break; } }
/// <summary> /// Update entities. /// </summary> /// <param name="client">SugarRestClient object.</param> /// <param name="request">The request object.</param> /// <param name="modelInfo">The entity model info.</param> /// <returns>SugarRestResponse object.</returns> public static SugarRestResponse ExecuteUpdates(this SugarRestClient client, SugarRestRequest request, ModelInfo modelInfo) { var sugarRestResponse = new SugarRestResponse(); var loginResponse = new LoginResponse(); try { var loginRequest = new LoginRequest { Url = request.Url, Username = request.Username, Password = request.Password }; loginResponse = Authentication.Login(loginRequest); JArray objectList = JsonConverterHelper.SerializeList(request.Parameter, modelInfo.Type); var selectFields = modelInfo.GetJsonPropertyNames(request.Options.SelectFields); var updateEntriesResponse = UpdateEntries.Run(loginResponse.SessionId, loginRequest.Url, request.ModuleName, objectList, selectFields); if (updateEntriesResponse != null) { sugarRestResponse.JsonRawRequest = updateEntriesResponse.JsonRawRequest; sugarRestResponse.JsonRawResponse = updateEntriesResponse.JsonRawResponse; if ((updateEntriesResponse.Ids != null) && (updateEntriesResponse.Ids.Count > 0)) { sugarRestResponse.Data = updateEntriesResponse.Ids; sugarRestResponse.JData = (updateEntriesResponse.Ids == null) ? null : JArray.FromObject(updateEntriesResponse.Ids).ToString(); sugarRestResponse.StatusCode = updateEntriesResponse.StatusCode; } else { sugarRestResponse.Error = updateEntriesResponse.Error; sugarRestResponse.StatusCode = updateEntriesResponse.StatusCode; } } return(sugarRestResponse); } catch (Exception exception) { sugarRestResponse.StatusCode = HttpStatusCode.InternalServerError; sugarRestResponse.Error = ErrorResponse.Format(exception, string.Empty); } finally { Authentication.Logout(request.Url, loginResponse.SessionId); } return(sugarRestResponse); }
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.Columns[e.ColumnIndex].DataPropertyName == "Days") { string title = dataGridView1.Rows[e.RowIndex].Cells[2].FormattedValue.ToString(); int days = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].FormattedValue.ToString()); foreach (Movie m in ReadEntries.AllMovies()) { if (m.Title == title) { dataGridView1.Rows[e.RowIndex].Cells[4].Value = Rental.getAmount(m.Price, days); MessageBox.Show("Rental data updated succesfully"); UpdateEntries.UpdateReJson("Days", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); } } } if (dataGridView1.Columns[e.ColumnIndex].DataPropertyName == "Name") { string name = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].FormattedValue.ToString(); foreach (Client c in ReadEntries.AllClients()) { if (c.Name == name) { dataGridView1.Rows[e.RowIndex].Cells[1].Value = c.Tel; MessageBox.Show("Rental data updated succesfully"); UpdateEntries.UpdateReJson("Name", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex, dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString()); } } } else if (dataGridView1.Columns[e.ColumnIndex].DataPropertyName == "Title") { string title = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].FormattedValue.ToString(); int days = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].FormattedValue.ToString()); foreach (Movie m in ReadEntries.AllMovies()) { if (m.Title == title) { dataGridView1.Rows[e.RowIndex].Cells[4].Value = Rental.getAmount(m.Price, days); MessageBox.Show("Rental data updated succesfully"); UpdateEntries.UpdateReJson("Title", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex, dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString()); } } } }
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.CurrentCell.ColumnIndex == 5) { UpdateEntries.UpdateClJson(orval, "Active", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); MessageBox.Show("Client data updated succesfully"); } var name = dataGridView1.CurrentCell.ColumnIndex; switch (name) { case 0: if (dataGridView1.CurrentCell.Value != null && UpdateEntries.CheckClient(fname: dataGridView1.CurrentCell.Value.ToString())) { UpdateEntries.UpdateClJson(orval, "Fname", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); MessageBox.Show("Client data updated succesfully"); } else { MessageBox.Show("Wrong client info"); dataGridView1.CurrentCell.Value = orval; } break; case 1: if (dataGridView1.CurrentCell.Value != null && UpdateEntries.CheckClient(lname: dataGridView1.CurrentCell.Value.ToString())) { UpdateEntries.UpdateClJson(orval, "Lname", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); MessageBox.Show("Client data updated succesfully"); } else { MessageBox.Show("Wrong client info"); dataGridView1.CurrentCell.Value = orval; } break; case 2: if (dataGridView1.CurrentCell.Value != null && UpdateEntries.CheckClient(email: dataGridView1.CurrentCell.Value.ToString())) { UpdateEntries.UpdateClJson(orval, "Email", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); MessageBox.Show("Client data updated succesfully"); } else { MessageBox.Show("Wrong client info"); dataGridView1.CurrentCell.Value = orval; } break; case 3: if (dataGridView1.CurrentCell.Value != null && UpdateEntries.CheckClient(tel: dataGridView1.CurrentCell.Value.ToString())) { UpdateEntries.UpdateClJson(orval, "Tel", dataGridView1.CurrentCell.Value.ToString(), dataGridView1.CurrentCell.RowIndex); MessageBox.Show("Client data updated succesfully"); } else { MessageBox.Show("Wrong client info"); dataGridView1.CurrentCell.Value = orval; } break; } }