/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridStochasticAgeTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridStochasticAgeTable.Rows[e.RowIndex].HeaderCell;
if (header.Value == null)
{
if (timeVarying == true)
{
string[] stochasticAgeTableRowHeaders = this.seqYears;
setStochasticAgeTableRowHeaders(stochasticAgeTableRowHeaders, numFleets);
}
else
{
if (multiFleetTable == true)
{
//Pass in one empty string since setStochasticAgeTableRowHeaders sets the header string
string[] stochasticAgeTableRowHeaders = { string.Empty };
setStochasticAgeTableRowHeaders(stochasticAgeTableRowHeaders, numFleets);
}
else
{
string[] stochasticAgeTableRowHeaders = { "All Years" };
setStochasticAgeTableRowHeaders(stochasticAgeTableRowHeaders, 1);
}
}
}
}
public void BeginEdit(DataGridViewRowHeaderCell c)
{
int ind = c.RowIndex;
int Top = D.ColumnHeadersHeight;
for (int i = 0; i < ind; i++)
{
Top += D.Rows[i].Height;
}
TextBox t = new TextBox();
t.Left = 1;
t.Width = D.RowHeadersWidth;
t.Top = Top;
t.Font = new Font(D.Font.Name, D.Font.Size + 2);
t.LostFocus += new EventHandler(EditHeader);
t.PreviewKeyDown += new PreviewKeyDownEventHandler(TextBoxKeyDown);
t.Tag = c;
if (c.Value != null)
{
t.Text = c.Value.ToString();
}
D.Controls.Add(t);
t.Focus();
}
private void btnDisplay_Click(object sender, EventArgs e)
{
if (dtr2.Value.Date > dtr1.Value.Date)
{
vwGrid.DataSource = Getdt();
try
{
for (int i = 0; i < vwGridUnpaid.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = vwGrid.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString();
vwGrid.Rows[i].HeaderCell = cell;
}
vwGrid.AutoResizeColumns();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Revise Date Selection...");
}
}
static public void AddRowTitle(DataGridView dgv, object HeaderVal)
{
DataGridViewRowHeaderCell row = new DataGridViewRowHeaderCell();
row.Value = HeaderVal;
//dgv.RowHeadersWidth = 15;
dgv.Rows.Add(row);
}
private void dataGridRecruitProb_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridRecruitProb.Rows[e.RowIndex].HeaderCell;
if (!(header.Value != null))
{
SetRecruitmentProbRowHeaders();
}
}
private void dataGridLv1ObservationTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridLv1ObservationTable.Rows[e.RowIndex].HeaderCell;
if (header.Value == null)
{
SetEmpiricalRowHeadsers(dataGridLv1ObservationTable);
}
}
private void dataGridLv2ObservationTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = this.dataGridLv2ObservationTable.Rows[e.RowIndex].HeaderCell;
if (!(header.Value != null))
{
base.SetEmpiricalRowHeadsers(this.dataGridLv2ObservationTable);
}
}
private void button3_Click(object sender, EventArgs e)
{
var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient";
string trncateBaleReg = "Truncate Table BaleRegForm";
string idInsertOn = "SET IDENTITY_INSERT BaleRegForm ON";
string idInsertOff = "SET IDENTITY_INSERT BaleRegForm OFF";
string query = "INSERT INTO BaleRegForm (BaleRegFormID, BaleRegFormCode, CreatedDate, BaleRegFormStatus, LocationID, GrowerID)"
+ "SELECT BaleRegFormID, BaleRegFormCode, CreatedDate, BaleRegFormStatus, LocationID, GrowerID"
+ " FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.BaleRegForm ";
try
{
int count = 0;
// string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'";
var sqlCon = new SqlConnection(conString00);
if (sqlCon.State != ConnectionState.Open)
{
sqlCon.Open();
// var sqlcmdTrncate = new SqlCommand(trncateBaleReg, sqlCon);
//sqlcmdTrncate.ExecuteNonQuery();
var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon);
var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon);
var sqlcomquery = new SqlCommand(query, sqlCon);
sqlcomidInsertOn.ExecuteNonQuery().ToString();
string result = sqlcomquery.ExecuteNonQuery().ToString();
sqlcomidInsertOff.ExecuteNonQuery().ToString();
sqlCon.Close();
MessageBox.Show(lblBaleRegform.Text + " Records Inserted...");
//reader.Dispose();
sqlCon.Close();
DataTable dt_ = new DataTable();
SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM BaleRegForm order by BaleregformID desc", sqlCon);
da_.Fill(dt_);
this.vwGridView.DataSource = dt_;
vwGridView.Show();
vwGridView.ScrollBars = ScrollBars.Both;
da_.Dispose();
for (int i = 0; i < vwGridView.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString();
vwGridView.Rows[i].HeaderCell = cell;
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message.ToString());
}
finally
{
}
btnBaleRegFormPost.BackColor = Color.Green;
}
private void button4_Click(object sender, EventArgs e)
{
var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient";
string sqlcmdTruncate = "Truncate Table Grower";
string idInsertOn = "SET IDENTITY_INSERT Grower ON";
string idInsertOff = "SET IDENTITY_INSERT Grower OFF";
string query = "INSERT INTO Grower (GrowerID, GrowerName, FatherName, Location, Address, ContactNumber, CNIC, GrowerCode, CaretakerID, Active_Ind, GrowerMaxWeightLimit)"
+ "SELECT GrowerID, GrowerName, FatherName, Location, Address, ContactNumber, CNIC, GrowerCode, CaretakerID, Active_Ind, GrowerMaxWeightLimit "
+ "FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.Grower";
try
{
int count = 0;
// string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'";
var sqlCon = new SqlConnection(conString00);
if (sqlCon.State != ConnectionState.Open)
{
sqlCon.Open();
// var sqlcmdTruncateGrower = new SqlCommand(sqlcmdTruncate, sqlCon);
// sqlcmdTruncateGrower.ExecuteNonQuery();
var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon);
var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon);
var sqlcomquery = new SqlCommand(query, sqlCon);
sqlcomidInsertOn.ExecuteNonQuery().ToString();
string result = sqlcomquery.ExecuteNonQuery().ToString();
sqlcomidInsertOff.ExecuteNonQuery().ToString();
sqlCon.Close();
MessageBox.Show(lblGrower.Text + "Records Inserted....");
//reader.Dispose();
sqlCon.Close();
DataTable dt_ = new DataTable();
SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM Grower order by growerid desc", sqlCon);
da_.Fill(dt_);
this.vwGridView.DataSource = dt_;
vwGridView.Show();
vwGridView.ScrollBars = ScrollBars.Both;
da_.Dispose();
for (int i = 0; i < vwGridView.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString();
vwGridView.Rows[i].HeaderCell = cell;
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message.ToString());
}
finally
{
}
btnPostGrower.BackColor = Color.Green;
}
private void countrow()
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = dataGridView1.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString();
dataGridView1.Rows[i].HeaderCell = cell;
}
}
private void dataGridObservations_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = this.dataGridObservations.Rows[e.RowIndex].HeaderCell;
if (!(header.Value != null))
{
SetRecruitPredictorRowHeaders(this.dataGridObservations);
}
}
private void button2_Click(object sender, EventArgs e)
{
var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient";
string truncate_ = "TRUNCATE TABLE BALE";
string idInsertOn = "SET IDENTITY_INSERT BALE ON";
string idInsertOff = "SET IDENTITY_INSERT BALE OFF";
string query = "INSERT INTO BALE (BaleID, Weight, Grade, Subgrade,Rate, GrowerID,Date, LotCode, BaleIDPK, BaleRegistrationFormID,Status,ReclassifiedSubgrade,ReclassifiedRate, ReclassifiedGrade, IsOrphanBale, IsReClassifiedExported)"
+ "SELECT BaleID, Weight, Grade, Subgrade,Rate, GrowerID, Date, LotCode,BaleIDPK, BaleRegistrationFormID,Status,ReclassifiedSubgrade,ReclassifiedRate, ReclassifiedGrade, IsOrphanBale,IsReClassifiedExported "
+ "FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.Bale";
try
{
int count = 0;
// string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'";
var sqlCon = new SqlConnection(conString00);
if (sqlCon.State != ConnectionState.Open)
{
sqlCon.Open();
//var sqlComTruncate = new SqlCommand(truncate_, sqlCon);
//sqlComTruncate.ExecuteNonQuery();
var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon);
var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon);
var sqlcomquery = new SqlCommand(query, sqlCon);
sqlcomidInsertOn.ExecuteNonQuery().ToString();
string result = sqlcomquery.ExecuteNonQuery().ToString();
sqlcomidInsertOff.ExecuteNonQuery().ToString();
sqlCon.Close();
MessageBox.Show(lblBale.Text + " Records Inserted...");
//reader.Dispose();
sqlCon.Close();
DataTable dt_ = new DataTable();
SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM BALE order by baleidPk desc", sqlCon);
da_.Fill(dt_);
this.vwGridView.DataSource = dt_;
vwGridView.Show();
vwGridView.ScrollBars = ScrollBars.Both;
da_.Dispose();
for (int i = 0; i < vwGridView.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString();
vwGridView.Rows[i].HeaderCell = cell;
}
this.btnBalePost.BackColor = Color.Green;
}
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message.ToString());
}
finally
{
}
}
private void AddRowNumbersToResults(DataGridView dataGridView)
{
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = dataGridView.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString().Trim();
dataGridView.Rows[i].HeaderCell = cell;
}
dataGridView.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
}
private void dataGridFractionMortality_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridFractionMortality.Rows[e.RowIndex].HeaderCell;
if (header.Value == null)
{
dataGridFractionMortality.Rows[0].HeaderCell.Value = "Fraction F Prior to Spawn";
dataGridFractionMortality.Rows[1].HeaderCell.Value = "Fraction M Prior to Spawn";
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridCVTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridCVTable.Rows[e.RowIndex].HeaderCell;
//header value is null
if (header.Value == null)
{
setCVTableRowHeaders();
}
}
private void button6_Click(object sender, EventArgs e)
{
var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient";
string sqlTruncateVoucher = "Truncate Table Voucher";
string idInsertOn = "SET IDENTITY_INSERT Voucher ON";
string idInsertOff = "SET IDENTITY_INSERT Voucher OFF";
string query = "INSERT INTO Voucher (VoucherID, Amount, OriginalPrintStatus, DuplicatePrintStatus, VoucherCode, LotID, BaleRegistrationFormID, GrowerID, PaymentDate, IsPrintedPayment, IsPrintedBank, status, IsPrintedMandi, PaymentMode, CancelationReason)"
+ "SELECT VoucherID, Amount, OriginalPrintStatus, DuplicatePrintStatus, VoucherCode, LotID, BaleRegistrationFormID, GrowerID, PaymentDate, IsPrintedPayment, IsPrintedBank, status, IsPrintedMandi, PaymentMode, CancelationReason FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.Voucher";
try
{
int count = 0;
// string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'";
var sqlCon = new SqlConnection(conString00);
if (sqlCon.State != ConnectionState.Open)
{
sqlCon.Open();
// var sqlcmdVoucher = new SqlCommand(sqlTruncateVoucher, sqlCon);
// sqlcmdVoucher.ExecuteNonQuery();
var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon);
var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon);
var sqlcomquery = new SqlCommand(query, sqlCon);
sqlcomidInsertOn.ExecuteNonQuery().ToString();
string result = sqlcomquery.ExecuteNonQuery().ToString();
sqlcomidInsertOff.ExecuteNonQuery().ToString();
sqlCon.Close();
MessageBox.Show(lblVoucher.Text + ". Records Inserted....");
//reader.Dispose();
sqlCon.Close();
DataTable dt_ = new DataTable();
SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM voucher", sqlCon);
da_.Fill(dt_);
this.vwGridView.DataSource = dt_;
vwGridView.Show();
vwGridView.ScrollBars = ScrollBars.Both;
da_.Dispose();
for (int i = 0; i < vwGridView.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString();
vwGridView.Rows[i].HeaderCell = cell;
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message.ToString());
}
finally
{
}
btnPostVoucher.BackColor = Color.Green;
}
private void btnpostcompany_Click(object sender, EventArgs e)
{
var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient";
string sqlTruncateVoucher = "Truncate Table Voucher";
string idInsertOn = "SET IDENTITY_INSERT [Company] ON";
string idInsertOff = "SET IDENTITY_INSERT [Company] OFF";
string query = "INSERT INTO [Company] ([CompanyID],[CompanyName],[CompanyCode],[CompanyAddress],[CompanyPhone],[Active_Ind])"
+ "SELECT [CompanyID],[CompanyName],[CompanyCode],[CompanyAddress],[CompanyPhone],[Active_Ind] FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.[Company]";
try
{
int count = 0;
// string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'";
var sqlCon = new SqlConnection(conString00);
if (sqlCon.State != ConnectionState.Open)
{
sqlCon.Open();
// var sqlcmdVoucher = new SqlCommand(sqlTruncateVoucher, sqlCon);
// sqlcmdVoucher.ExecuteNonQuery();
var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon);
var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon);
var sqlcomquery = new SqlCommand(query, sqlCon);
sqlcomidInsertOn.ExecuteNonQuery().ToString();
string result = sqlcomquery.ExecuteNonQuery().ToString();
sqlcomidInsertOff.ExecuteNonQuery().ToString();
sqlCon.Close();
MessageBox.Show(lblcompany.Text + ". Records Inserted....");
//reader.Dispose();
sqlCon.Close();
DataTable dt_ = new DataTable();
SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM [Company]", sqlCon);
da_.Fill(dt_);
this.vwGridView.DataSource = dt_;
vwGridView.Show();
vwGridView.ScrollBars = ScrollBars.Both;
da_.Dispose();
for (int i = 0; i < vwGridView.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString();
vwGridView.Rows[i].HeaderCell = cell;
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message.ToString());
}
finally
{
}
btnpostcompany.BackColor = Color.Green;
}
private void btnDisplay_Click(object sender, EventArgs e)
{
vwGrid.DataSource=null;
try
{
//string having = "cast(bg.CreatedDate as Date)='" + dtPurchase.Value.Date.ToShortDateString() + "' OR v.VoucherCode='" + txtvcode.Text.Trim() + "' OR vd.Amount='" + Convert.ToInt32(txtamount.Text.Trim()) + "' OR cast(v.PaymentDate as Date)='" + dtPayment.Value.Date.ToShortDateString() + "'";
string db = cmbDatabase.SelectedItem.ToString();
string prdate = dtPurchase.Value.Date.ToShortDateString();
string pydate = dtPayment.Value.Date.ToShortDateString();
string vcode = txtvcode.Text;
if (cmbDatabase.SelectedItem != null)
{
vwGrid.DataSource = "";
var da_ = new SqlDataAdapter("SELECT "
+ "SUM(vd.Amount) AS Amount,"
+ "v.VoucherCode,"
+ "g.GrowerName,"
+ "bg.CreatedDate AS PurchaseDate, "
+ "v.PaymentDate, "
+ "v.VoucherID, "
+ "v.GrowerID, "
+ "g.FatherName, "
+ "g.CNIC, "
+ "g.ContactNumber,"
+ "l.LocationName "
+ " FROM [" + cmbDatabase.SelectedItem + "].dbo.Voucher v INNER JOIN "
+ " [" + cmbDatabase.SelectedItem + "].dbo.VoucherDetail vd ON v.VoucherID = vd.VoucherId INNER JOIN "
+ " [" + cmbDatabase.SelectedItem + "].dbo.Grower g ON v.GrowerID = g.GrowerID INNER JOIN "
+ " [" + cmbDatabase.SelectedItem + "].dbo.Bale b ON b.BaleID = vd.BaleId INNER JOIN "
+ " [" + cmbDatabase.SelectedItem + "].dbo.BaleRegForm bg ON g.GrowerID = bg.GrowerID AND v.LotID = bg.BaleRegFormCode AND "
+ " v.BaleRegistrationFormID = bg.BaleRegFormID INNER JOIN "
+ " [" + cmbDatabase.SelectedItem + "].dbo.Location l ON bg.LocationID = l.LocationID "
+ " GROUP BY v.PaymentDate, g.ContactNumber, v.GrowerID, g.CNIC, v.VoucherID, v.VoucherCode, g.GrowerName, g.FatherName, bg.CreatedDate, l.LocationName "
+ " HAVING (CAST(bg.CreatedDate as Date)='"+ dtPurchase.Value.Date.ToShortDateString()+" ' OR v.VoucherCode='" + txtvcode.Text.Trim() + "' OR CAST(v.PaymentDate as Date)='" + dtPayment.Value.Date.ToShortDateString()+ "') ORDER BY v.VoucherID", UniCon);
var dt_ = new DataTable();
da_.Fill(dt_);
this.vwGrid.DataSource = dt_;
vwGrid.Show();
vwGrid.ScrollBars = ScrollBars.Both;
da_.Dispose();
for (int i = 0; i < vwGrid.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = vwGrid.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString();
vwGrid.Rows[i].HeaderCell = cell;
}
da_.Dispose();
}
}
catch (Exception ex)
{
}
}
public void DataGridViewRowHeaderCellAccessibleObject_Parent_ReturnsExpected()
{
using DataGridView control = new();
control.Columns.Add("Column 1", "Header text 1");
DataGridViewRowHeaderCell cell = control.Rows[0].HeaderCell;
var accessibleObject = (DataGridViewRowHeaderCellAccessibleObject)cell.AccessibilityObject;
Assert.Equal(cell.OwningRow.AccessibilityObject, accessibleObject.Parent);
Assert.False(control.IsHandleCreated);
}
private void dataGridComboBoxSelectRecruitModels_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridComboBoxSelectRecruitModels.Rows[e.RowIndex].HeaderCell;
if (!(header.Value != null))
{
for (int i = 0; i < dataGridComboBoxSelectRecruitModels.Rows.Count; i++)
{
dataGridComboBoxSelectRecruitModels.Rows[i].HeaderCell.Value = "Selection " + (i + 1);
}
}
}
private void dataGridProbabilityTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridProbabilityTable.Rows[e.RowIndex].HeaderCell;
if (!(header.Value != null))
{
for (int i = 0; i < dataGridProbabilityTable.Rows.Count; i++)
{
dataGridProbabilityTable.Rows[i].HeaderCell.Value = "SSB Level-" + (i + 1);
}
}
}
private void dataGridSSBTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridSSBTable.Rows[e.RowIndex].HeaderCell;
if (!(header.Value != null))
{
for (int i = 0; i < dataGridSSBTable.Rows.Count; i++)
{
dataGridSSBTable.Rows[i].HeaderCell.Value = (i + 1).ToString();
}
}
}
public void DataGridViewRowHeaderCellAccessibleObject_DoDefaultAction_DoesNothing_IfHandleIsNotCreated(DataGridViewSelectionMode mode)
{
using DataGridView control = new();
control.SelectionMode = mode;
control.Columns.Add("Column 1", "Header text 1");
DataGridViewRowHeaderCell cell = control.Rows[0].HeaderCell;
Assert.False(cell.OwningRow.Selected);
cell.AccessibilityObject.DoDefaultAction();
Assert.False(cell.OwningRow.Selected);
Assert.False(control.IsHandleCreated);
}
private void dataGridFixedRecruitment_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridFixedRecruitment.Rows[e.RowIndex].HeaderCell;
if (!(header.Value != null))
{
if (dataGridFixedRecruitment.Rows.Count > 0)
{
for (int i = 1; i < seqYears.Count(); i++)
{
dataGridFixedRecruitment.Rows[i - 1].HeaderCell.Value = seqYears[i];
}
}
}
}
private void dataGridHarvestScenarioTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRowHeaderCell header = dataGridHarvestScenarioTable.Rows[e.RowIndex].HeaderCell;
if (!(header.Value != null))
{
//set HarvestScenarioTable RowHeaders
int iyear = 0;
foreach (DataGridViewRow yearRow in dataGridHarvestScenarioTable.Rows)
{
yearRow.HeaderCell.Value = seqYears[iyear];
iyear++;
}
}
}
public void DataGridViewRowHeaderCellAccessibleObject_DoDefaultAction_WorksExpected(DataGridViewSelectionMode mode, bool expected)
{
using DataGridView control = new();
control.SelectionMode = mode;
control.Columns.Add("Column 1", "Header text 1");
DataGridViewRowHeaderCell cell = control.Rows[0].HeaderCell;
control.CreateControl();
Assert.False(cell.OwningRow.Selected);
cell.AccessibilityObject.DoDefaultAction();
Assert.Equal(expected, cell.OwningRow.Selected);
Assert.True(control.IsHandleCreated);
}
private void ShowPaid(string depot_, string prdate_, string pydate_)
{
DataTable dt_ = new DataTable();
try
{
var da_ = new SqlDataAdapter("SELECT "
+ "Depot, PurchaseDate, "
+ "PaymentDate, VCount, "
+ "Amount, Amount_Paid, "
+ "DatePaid, Status, Remarks "
+ " FROM vwPaid001 "
+ " WHERE (cast(PurchaseDate as datetime) = '" + Convert.ToDateTime(prdate_) + "' OR (cast(PaymentDate as datetime) = '" + Convert.ToDateTime(pydate_) + "' )) AND Depot = '" + depot_ + "'", new SqlConnection(UniCon));
da_.Fill(dt_);
vwGridPaid.DataSource = dt_;
for (int i = 0; i < vwGridPaid.Rows.Count; i++)
{
DataGridViewRowHeaderCell cell = vwGridPaid.Rows[i].HeaderCell;
cell.Value = (i + 1).ToString();
vwGridPaid.Rows[i].HeaderCell = cell;
}
int sumPaid = 0;
int sumPaidBy = 0;
int sumVcount = 0;
foreach (DataRow row_ in dt_.Rows)
{
sumPaid += Convert.ToInt32(row_["Amount"]);
sumPaidBy += Convert.ToInt32(row_["Amount_Paid"]);
sumVcount += Convert.ToInt32(row_["VCount"]);
}
txtAmountP.Text = sumPaid.ToString();
txtAmountPaidP.Text = sumPaidBy.ToString();
txtNoVp.Text = sumVcount.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ShowPLSGrid(List <PLS1Result> clst)
{
this.gridPLS.Rows.Clear();
this.gridId.Visible = false;
this.gridFit.Visible = false;
this.gridPLS.Visible = true;
this.gridItg.Visible = false;
int k = 1;
foreach (var c in clst)
{
try
{
var factor = c.Factor - 1;
var cell = new DataGridViewRowHeaderCell()
{
Value = k.ToString(),
};
var row = new DataGridViewRow()
{
HeaderCell = cell
};
row.CreateCells(this.gridPLS,
c.Comp.Name,
c.MahDist[factor].ToString("F4"),
c.MDMin.ToString("F4"),
c.SR[factor].ToString("f4"),
c.SRMin.ToString("F4"),
c.ND[factor].ToString("F4"),
c.NDMin.ToString("F4")
);
this.gridPLS.Rows.Add(row);
k++;
}
catch
{
}
}
}
private void ShowfitGrid(FittingResult result)
{
this.gridFit.Rows.Clear();
this.gridId.Visible = false;
this.gridPLS.Visible = false;
this.gridFit.Visible = true;
this.gridItg.Visible = false;
if (result == null || result.Specs.Length == 0)
{
return;
}
int k = 1;
foreach (var item in result.Specs)
{
var cell = new DataGridViewRowHeaderCell()
{
Value = k.ToString()
};
var row = new MyDataFitRow()
{
Item = item,
HeaderCell = cell
};
if (k == 1)
{
row.CreateCells(this.gridFit, item.Spec.UUID, item.Rate.ToString("F4"), result.TQ.ToString("F4"), result.SQ.ToString("F4"));
}
else
{
row.CreateCells(this.gridFit, item.Spec.UUID, item.Rate.ToString("F4"));
}
this.gridFit.Rows.Add(row);
k++;
}
}
private void ShowIdGrid(IdentifyResult result, int num, int numOfId)
{
this.gridId.Rows.Clear();
this.gridId.Visible = true;
this.gridFit.Visible = false;
this.gridPLS.Visible = false;
this.gridItg.Visible = false;
if (result == null || result.Items.Length == 0)
{
return;
}
result = IdentifyModel.GetPredictValue(result, num, numOfId);
int k = 1;
foreach (var r in result.Items)
{
if (k > num)
{
break;
}
var cell = new DataGridViewRowHeaderCell()
{
Value = k.ToString()
};
var row = new MyDataIdRow()
{
Item = r,
HeaderCell = cell
};
row.CreateCells(this.gridId, r.Spec.UUID, r.TQ.ToString("F4"), r.SQ.ToString("F4"),
r.Result);
this.gridId.Rows.Add(row);
k++;
}
}
