private void button9_Click(object sender, EventArgs e)
{
if (textBox8.Text.Trim() != "")
{
button9.Enabled = false;
Cursor.Current = Cursors.WaitCursor;
General.ExcelFormat objExcelFormat = new General.ExcelFormat();
DataSet ds = new DataSet();
int carid1 = Convert.ToInt32(textBox8.Text);
string dt = DateTime.Now.ToString();
ds = objSubmitionDetailsBL.GetpostedURL(carid1, dt, GlobalLogId.globallogidVar);
objExcelFormat.ProcessedSheetExcel(carid1, ds, comboBox3.Text);
Cursor.Current = Cursors.Default;
MessageBox.Show("Downloaded to ExcelSheet Sucessfully");
button9.Enabled = true;
}
else
{
MessageBox.Show("Please Enter CarId");
textBox8.Text = "";
textBox8.Focus();
}
}
private void dataGridView3_CellClick(object sender, DataGridViewCellEventArgs e)
{
string carid = string.Empty;
label43.Visible = true;
Label42.Visible = true;
label43.Text = "";
pi = dataGridView3.SelectedCells[0].RowIndex;
carid = dataGridView3.Rows[pi].Cells[0].Value.ToString();
string stcarid = carid.ToString();
if (stcarid != "")
{
if (e.ColumnIndex == 7)
{
if (e.RowIndex != -1)
{
int val1 = Convert.ToInt32(dataGridView3.Rows[pi].Cells[7].Value.ToString());
if (val1 != 0)
{
label43.Text = "CarId: " + carid.ToString();
DataSet dtsp1 = new DataSet();
dtsp1 = objSubmitionDetailsBL.MultigetPendingSites(carid);
dataGridView4.DataSource = dtsp1.Tables[0];
dataGridView4.Columns["sitename"].ReadOnly = true;
// dataGridView4.Columns[0].DefaultCellStyle.ForeColor = Color.Red;
dataGridView4.Columns[1].DefaultCellStyle.ForeColor = Color.Red;
dataGridView4.Columns[2].DefaultCellStyle.ForeColor = Color.Red;
dataGridView4.Columns[2].DefaultCellStyle.Font = new Font(dataGridView4.DefaultCellStyle.Font, FontStyle.Underline);
// dataGridView4.Columns[2].DefaultCellStyle.Font = new Font(dataGridView1.DefaultCellStyle.Font, FontStyle.Underline);
// DataGridViewColumn cldtg1 = dataGridView4.Columns[0];
// cldtg1.Width = 145;
DataGridViewColumn cldtg2 = dataGridView4.Columns[1];
cldtg2.Width = 145;
DataGridViewColumn cldtg3 = dataGridView4.Columns[2];
cldtg3.Width = 77;
this.dataGridView4.Columns["StId"].Visible = false;
this.dataGridView4.Columns["UrlId"].Visible = false;
this.dataGridView4.Columns["CarId"].Visible = false;
this.dataGridView4.Columns["URL"].Visible = false;
this.dataGridView4.Columns["URLSID"].Visible = false;
this.dataGridView4.Columns["Siteid"].Visible = false;
this.dataGridView4.Columns["UrlPostDate"].Visible = false;
}
else
{
dataGridView4.DataSource = null;
//dataGridView4.DataBind();
// dataGridView4.Rows.Clear();
}
}
}
if (e.ColumnIndex == 8)
{
if (e.RowIndex != -1)
{
int val = Convert.ToInt32(dataGridView3.Rows[pi].Cells[8].Value.ToString());
if (val != 0)
{
label43.Text = "CarId: " + carid.ToString();
DataSet dtsp2 = new DataSet();
dtsp2 = objSubmitionDetailsBL.MultigetPendingSites1(carid);
dataGridView4.DataSource = dtsp2.Tables[0];
dataGridView4.Columns["sitename"].ReadOnly = true;
dataGridView4.Columns[1].DefaultCellStyle.ForeColor = Color.Red;
dataGridView4.Columns[2].DefaultCellStyle.ForeColor = Color.Red;
dataGridView4.Columns[3].DefaultCellStyle.ForeColor = Color.Red;
dataGridView4.Columns[2].DefaultCellStyle.Font = new Font(dataGridView4.DefaultCellStyle.Font, FontStyle.Underline);
// dataGridView4.Columns[2].DefaultCellStyle.Font = new Font(dataGridView1.DefaultCellStyle.Font, FontStyle.Underline);
DataGridViewColumn cldtg1 = dataGridView4.Columns[1];
cldtg1.Width = 145;
DataGridViewColumn cldtg2 = dataGridView4.Columns[2];
cldtg2.Width = 125;
DataGridViewColumn cldtg3 = dataGridView4.Columns[3];
cldtg3.Width = 77;
this.dataGridView4.Columns["StId"].Visible = false;
this.dataGridView4.Columns["UrlId"].Visible = false;
this.dataGridView4.Columns["CarId"].Visible = false;
this.dataGridView4.Columns["URL"].Visible = false;
this.dataGridView4.Columns["URLSID"].Visible = false;
this.dataGridView4.Columns["Siteid"].Visible = false;
this.dataGridView4.Columns["UrlPostDate"].Visible = false;
}
else
{
// dataGridView4.Rows.Count;
// for (int i = 0; i < dataGridView4.Rows.Count; i++)
// {
dataGridView4.DataSource = null;
//dataGridView4.Columns.Clear();
// dataGridView4.Rows.RemoveAt(i);
// }
}
}
}
else if (e.ColumnIndex == 0)
{
Cursor.Current = Cursors.WaitCursor;
General.ExcelFormat objExcelFormat = new General.ExcelFormat();
DataSet ds = new DataSet();
int carid1 = Convert.ToInt32(carid);
string dt = DateTime.Now.ToString();
ds = objSubmitionDetailsBL.GetpostedURL(carid1, dt, GlobalLogId.globallogidVar);
objExcelFormat.ProcessedSheetExcel(carid1, ds, comboBox3.Text);
Cursor.Current = Cursors.Default;
MessageBox.Show("Downloaded to ExcelSheet Sucessfully");
}
}
if (e.ColumnIndex == 4)
{
DataSet dtsp1 = new DataSet();
dtsp1 = objSubmitionDetailsBL.MultigetpostedSites(carid);
dataGridView4.DataSource = dtsp1.Tables[0];
dataGridView4.Columns[0].DefaultCellStyle.ForeColor = Color.Black;
dataGridView4.Columns[1].DefaultCellStyle.ForeColor = Color.Black;
DataGridViewColumn postdlst1 = dataGridView4.Columns[0];
postdlst1.Width = 150;
DataGridViewColumn postdlst2 = dataGridView4.Columns[1];
postdlst2.Width = 100;
label43.Text = "CarId: " + carid.ToString();
}
}
private void button11_Click(object sender, EventArgs e)
{
if ((comboBox3.Text.Trim() != "") || (textBox9.Text.Trim() != ""))
{
Cursor.Current = Cursors.WaitCursor;
string dt = string.Empty;
General.ExcelFormat objExcelFormat = new General.ExcelFormat();
DataSet ds = new DataSet();
int carid1 = 0;
if (comboBox3.Text.Trim() != "")
{
button9.Enabled = false;
string month = "";
//dt = DateTime.Now.ToString("yyyy-MM");
if (comboBox3.Text.Length != 2)
dateoftoday = 0 + comboBox3.Text;
else
dateoftoday = comboBox3.Text;
if (DateTime.Now.Month.ToString().Length != 2)
month = "0" + DateTime.Now.Month;
else month = DateTime.Now.Month.ToString();
dt = DateTime.Now.Year + "/" + month + "/" + dateoftoday;
dt = dt.Replace("-", "/");
//dt = dt + "/" + dateoftoday;
carid1 = 0;
}
else if (textBox9.Text.Trim() != "")
{
dt = DateTime.Now.ToString("yyyy-MM-dd");
//dt = textBox9.Text+"/" + DateTime.Now.Month+"/" + DateTime.Now.Year;
dt = dt.Replace("-", "/");
carid1 = Convert.ToInt32(textBox9.Text);
}
// DateTime t1 = DateTime.Now;
// t1 = Convert.ToDateTime(t1);
// // t1 = DateTime.Parse(t1);
// DateTime t2 = Convert.ToDateTime("00:01:00 AM");
//int t= TimeSpan.Compare(t1.TimeOfDay, t2.TimeOfDay);
//int i = DateTime.Compare(t1,t2);
////t2 = DateTime.Parse(t2);
//if (i > 0)
//{
//}
ds = objSubmitionDetailsBL.GetpostedURL(carid1, dt, GlobalLogId.globallogidVar);
objExcelFormat.ProcessedSheetExcel(carid1, ds, comboBox3.Text);
DataSet ds1 = objSubmitionDetailsBL.GetCarIdCount(carid1, dt, GlobalLogId.globallogidVar);
if (ds1.Tables[0].Rows.Count > 0)
label15.Text = ds1.Tables[0].Rows[0][0].ToString();
else
label15.Text = "No Postings Found";
Cursor.Current = Cursors.Default;
MessageBox.Show("Downloaded to ExcelSheet Sucessfully");
button9.Enabled = true;
}
else
{
MessageBox.Show("Please Select Date or enter Date");
comboBox3.Text = "";
comboBox3.Focus();
}
}
