private void bUpdata_Click(object sender, EventArgs e)
{
String res = "";
try
{
for (int i = 0; i < dgvSelected.Rows.Count; i++)
{
bandSelected = dgvSelected.Rows[i];
if (bandSelected.Visible)
{
row = dgvSelected.Rows[i];
SQL = "UPDATE showcase SET rent=" + row.Cells[1].Value.ToString() + " ,genre ='" + row.Cells[2].Value.ToString() + "' ,category='" + row.Cells[3].Value.ToString() + "' WHERE showcaseid='" + row.Cells[0].Value.ToString() + "';";
res += "Showcase:" + row.Cells[0].Value.ToString() + " IN " + branchName + " rent : " + row.Cells[1].Value.ToString() + ", genre : " + row.Cells[2].Value.ToString() + ", category : " + row.Cells[3].Value.ToString() + " Is updated \n";
cmd = new MySqlCommand(SQL, FormContainer.conn);
myData = cmd.ExecuteReader();
myData.Close();
}
}
//reset table
dgvShowcaseList.Rows.Clear();
dgvSelected.Rows.Clear();
initializeShowcaseRecord(formID);
initializeAvailibility();
}catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error " + ex.Number + " : " + ex.Message);
}
MessageBox.Show(res);
}
public void initializeShowcaseRecord(String id)
{
try
{
SQL = "select showcaseid,rent,genre,category from showcase WHERE branchid ='" + id + "';";
cmd = new MySqlCommand(SQL, FormContainer.conn);
myData = cmd.ExecuteReader();
while (myData.Read())
{
dgvShowcaseList.Rows.Add(myData.GetString(0), myData.GetInt64(1), myData.GetString(2), myData.GetString(3));
dgvSelected.Rows.Add(myData.GetString(0), myData.GetInt64(1), myData.GetString(2), myData.GetString(3), id);
}
myData.Close();
for (int i = 0; i < dgvSelected.Rows.Count; i++)
{
bandSelected = dgvSelected.Rows[i];
bandSelected.Visible = false;
}
tbSid.ResetText();
tbRent.ResetText();
cmbCategory.ResetText();
cbPrivate.Checked = false;
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error " + ex.Number + " : " + ex.Message);
}
}
private static void FreezeBand(DataGridViewBand band)
{
band.Frozen = true;
DataGridViewCellStyle style = new DataGridViewCellStyle();
style.BackColor = Color.WhiteSmoke;
band.DefaultCellStyle = style;
}
private static void FixedColumn(DataGridViewBand band)
{
band.Frozen = true;
DataGridViewCellStyle style = new DataGridViewCellStyle();
style.BackColor = Color.Wheat;
band.DefaultCellStyle = style;
}
//---------------------------------------------------------------------
protected bool AddExcludedColumn(TFind findValue, TFind columnFindValue, DataGridViewBand column)
{
if (column == null || findValue.Equals(columnFindValue))
{
return(false);
}
_cacheExcludedColumnIndexCollectionByTypeFind.Add(column.Index);
return(true);
}
private void sUpdata_Click(object sender, EventArgs e)
{
if (row != null)
{
String supdataSCid, supdataGenre, supdatacategory, supdataBranchid;
decimal supdataRent;
supdataSCid = tbSid.Text;
supdataGenre = row.Cells[2].Value.ToString();
supdatacategory = cmbCategory.Text;
supdataRent = tbRent.Value;
supdataBranchid = row.Cells[4].Value.ToString();
if (supdataSCid != "")
{
try
{
SQL = "UPDATE showcase SET rent=" + supdataRent + " ,genre ='" + supdataGenre + "' ,category='" + supdatacategory + "' WHERE showcaseid='" + supdataSCid + "';";
cmd = new MySqlCommand(SQL, FormContainer.conn);
myData = cmd.ExecuteReader();
myData.Close();
dgvShowcaseList.Sort(dgvShowcaseList.Columns[0], ListSortDirection.Ascending);
//get eachrow visible
ArrayList rowVisible = new ArrayList();
for (int i = 0; i < dgvShowcaseList.Rows.Count; i++)
{
DataGridViewBand getVisrow = dgvShowcaseList.Rows[i];
rowVisible.Add(getVisrow.Visible);
}
//reset table
dgvShowcaseList.Rows.Clear();
//SQL=>select showcaseid,rent,genre,category from showcase WHERE branchid ='branchid';
SQL = "select showcaseid,rent,genre,category from showcase WHERE branchid ='" + supdataBranchid + "';";
cmd = new MySqlCommand(SQL, FormContainer.conn);
myData = cmd.ExecuteReader();
while (myData.Read())
{
dgvShowcaseList.Rows.Add(myData.GetString(0), myData.GetInt64(1), myData.GetString(2), myData.GetString(3));
}
myData.Close();
initializeAvailibility();
for (int i = 0; i < dgvShowcaseList.Rows.Count; i++)
{
DataGridViewBand getVisrow = dgvShowcaseList.Rows[i];
getVisrow.Visible = (Boolean)rowVisible[i];
}
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error " + ex.Number + " : " + ex.Message);
}
MessageBox.Show("Showcase:" + supdataSCid + " IN " + branchName + " rent : " + supdataRent + ", genre : " + supdataGenre + ", category : " + supdatacategory + " Is updated");
}
}
}
private string GetSelectedValue(DataGridViewBand item)
{
try
{
var rowindex = dataGridView1.CurrentCell.RowIndex;
var selectedVal = dataGridView1.Rows[rowindex].Cells[item.Index].Value.ToString();
return(string.IsNullOrEmpty(selectedVal) ? null : selectedVal);
}
catch
{
MessageBox.Show(@"Не выбрана строка");
return(null);
}
}
public static void SetBackColor([NotNull] DataGridViewBand band,
[NotNull] LogEventItem item)
{
Assert.ArgumentNotNull(band, nameof(band));
Assert.ArgumentNotNull(item, nameof(item));
Color backColor = GetBackColor(item);
if (backColor.IsEmpty)
{
return;
}
SetBackColor(band, backColor);
}
private void dgvSelected_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
row = this.dgvSelected.Rows[e.RowIndex];
String sclSCid = row.Cells[0].Value.ToString();
int i = 0;
String selectedSCid = "";
do
{
selectedSCid = dgvShowcaseList.Rows[i].Cells[0].Value.ToString();
i++;
} while (sclSCid != selectedSCid);
bandlist = dgvShowcaseList.Rows[i - 1];
bandlist.Visible = true;
bandSelected = dgvSelected.Rows[e.RowIndex];
bandSelected.Visible = false;
}
private void dgvShowcaseList_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
{
string showcaseIDselected;
string colname;
try
{
showcaseIDselected = dgvShowcaseList[0, e.RowIndex].Value.ToString();
}
catch (ArgumentOutOfRangeException)
{
showcaseIDselected = null;
}
colname = dgvShowcaseList.Columns[e.ColumnIndex].Name;
if (colname == "Select")
{
try
{
if (e.RowIndex != -1)
{
if (dgvShowcaseList[availability.Index, e.RowIndex].Style.BackColor == Color.LimeGreen)
{
row = this.dgvShowcaseList.Rows[e.RowIndex];
String sclSCid = row.Cells[0].Value.ToString();
int i = 0;
String selectedSCid = "";
do
{
selectedSCid = dgvSelected.Rows[i].Cells[0].Value.ToString();
i++;
} while (sclSCid != selectedSCid);
bandlist = dgvShowcaseList.Rows[e.RowIndex];
bandlist.Visible = false;
bandSelected = dgvSelected.Rows[i - 1];
bandSelected.Visible = true;
//dgvSelected.Rows.Add(row.Cells[0].Value.ToString(), row.Cells[1].Value.ToString(), row.Cells[2].Value.ToString(), row.Cells[3].Value.ToString());
}
}
}
catch (ArgumentNullException)
{
//cancel event when clicking on column header
}
}
}
private static void SetBackColor(DataGridViewBand band, Color color)
{
band.DefaultCellStyle.BackColor = color;
}
private static void SetBandColor(DataGridViewBand band, Color color)
{
band.Tag = color;
}
// Turn off user's ability to resize a column.
private void Button7_Click(object sender, EventArgs e)
{
DataGridViewBand band = dataGridView.Columns[0];
band.Resizable = DataGridViewTriState.False;
}
// Hide a band of cells.
private void Button6_Click(object sender, System.EventArgs e)
{
DataGridViewBand band = dataGridView.Rows[3];
band.Visible = false;
}
private static LogEventItem GetLogEventItem(DataGridViewBand row)
{
Assert.ArgumentNotNull(row, nameof(row));
return(row.Tag as LogEventItem);
}
