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