public void loadGridView(string click)
{
try
{
int Count = 0;
string Modified_Tick = string.Empty;
//if (Convert.ToInt32(Session["TicketTypeID"]) != 6 & Convert.ToInt32(Session["TicketTypeID"]) != 0)
if (TicketTypeID != 6 & TicketTypeID != 0)
{
//string[] str = tbComplainTicketNo.Text.Split("-");
string split = tbComplainTicketNo.Text;
string[] str = split.Split('-');
Count = 4;
Modified_Tick = string.Concat(str[0]) + "-" + string.Concat(str[1]) + "-" + string.Concat(str[2]);
dt = objBSS.SearchComplainCircuits(Modified_Tick, 0, "", "", "", "", 0, 0, 0, "",
0, 0, 0, 0, Convert.ToDateTime("1/1/1900"), Convert.ToDateTime("1/1/1900"), 0, 0, 0, Count,
"", 0, 0, 0, 0, 0);
}
else if (TicketTypeID == 6)
{
Count = 3;
Modified_Tick = tbComplainTicketNo.Text;
dt = objBSS.SearchComplainCircuits(Modified_Tick, 0, "", "", "", "", 0, 0, 0, "",
0, 0, 0, 0, Convert.ToDateTime("1/1/1900"), Convert.ToDateTime("1/1/1900"), 0, 0, 0, Count,
"", 0, 0, 0, 0, 0);
}
DataGridCount = dt.Rows.Count;
if (dt.Rows.Count > 0)
{
lblTotalCount.Text = Convert.ToString(dt.Rows.Count);
gvActiveCircuits.DataSource = dt;
gvActiveCircuits.DataBind();
//GridViewRowInfo lastRow1 = RadGrid1.Rows[RadGrid1.Rows.Count - 1];
//lastRow1.IsSelected = true;
//foreach (GridViewRow row in GridView1.Rows)
//{
// //string abc = row.Cells[3].Text;
// if (row.Cells[5].Text == "Solved")
// {
// }
//}
}
else
{
lblTotalCount.Text = "0";
gvActiveCircuits.DataSource = null;
//RadGrid1.Rows.clear();
}
}
catch (Exception)
{
throw;
}
}
public void loadGridView(string click)
{
try
{
int Count = 0;
string Modified_Tick = string.Empty;
if (TicketTypeID != 6 & TicketTypeID != 0)
{
//string[] str = tbComplainTicketNo.Text.Split(
string split = tbComplainTicketNo.Text;
string[] str = split.Split('-');
Count = 4;
Modified_Tick = string.Concat(str[0]) + "-" + string.Concat(str[1]) + "-" + string.Concat(str[2]);
dt = objBSS.SearchComplainCircuits(Modified_Tick, 0, "", "", "", "", 4, 0, 0, "",
0, 0, 0, 0, Convert.ToDateTime("1/1/1900"), Convert.ToDateTime("1/1/1900"), 0, 0, 0, Count,
"", 0, 0, 0, 0, 0);
}
else if (TicketTypeID == 6)
{
Count = 3;
Modified_Tick = tbComplainTicketNo.Text;
dt = objBSS.SearchComplainCircuits(Modified_Tick, 0, "", "", "", "", 0, 0, 0, "",
0, 0, 0, 0, Convert.ToDateTime("1/1/1900"), Convert.ToDateTime("1/1/1900"), 0, 0, 0, Count,
"", 0, 0, 0, 0, 0);
}
DataGridCount = dt.Rows.Count;
if (dt.Rows.Count > 0)
{
lblTotalCount.Text = Convert.ToString(dt.Rows.Count);
gvActiveCircuits.DataSource = dt;
gvActiveCircuits.DataBind();
}
else
{
lblTotalCount.Text = "0";
gvActiveCircuits.DataSource = null;
gvActiveCircuits.DataBind();
//gvActiveCircuits.Rows.Clear();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void loadGridView()
{
try
{
int Count = 0;
string Modified_Tick = string.Empty;
if (TicketTypeID != 6 & TicketTypeID != 0)
{
string[] str = tbComplainTicketNo.Text.Split('-');
Modified_Tick = "0" + "-" + "1" + "-" + "2";
Count = 4;
dt = objBSS.SearchComplainCircuits(Modified_Tick, 0, "", "", "", "", 1, 0, 0, "",
0, 0, 0, 0, Convert.ToDateTime("1/1/1900"), Convert.ToDateTime("1/1/1900"), 0, 0, 0, Count,
"", 0, 0, 0, 0, 0);
}
else if (TicketTypeID == 6)
{
Modified_Tick = tbComplainTicketNo.Text;
Count = 3;
dt = objBSS.SearchComplainCircuits(Modified_Tick, 0, "", "", "", "", 0, 0, 0, "",
0, 0, 0, 0, Convert.ToDateTime("1/1/1900"), Convert.ToDateTime("1/1/1900"), 0, 0, 0, Count,
"", 0, 0, 0, 0, 0);
}
DataGridCount = dt.Rows.Count;
if (dt.Rows.Count > 0)
{
lblTotalCount.Text = Convert.ToString(dt.Rows.Count);
gvActiveCircuits.DataSource = dt;
}
else
{
// lblCount.Text = "0";
gvActiveCircuits.DataSource = null;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void SetInitialRow()
{
System.DateTime sysdate = DateTime.MinValue;
DataTable dt_SearchComplainCirciuits = objBSS.SearchComplainCircuits("", 0, "", "", "", "", 4, 0, 0, "", 0, 0, 0, 0, sysdate, sysdate, 0, Convert.ToInt32(Session["DepartmentID"]), 0, 0, "OM", 0, 0, 0, 0, 0);
GVTeam.DataSource = dt_SearchComplainCirciuits;
GVTeam.DataBind();
//Store the DataTable in ViewState for future reference
ViewState["CurrentTable"] = dt_SearchComplainCirciuits;
//Bind the Gridview
GVTeam.DataSource = dt_SearchComplainCirciuits;
GVTeam.DataBind();
//After binding the gridview, we can then extract and fill the DropDownList with Data
for (int i = 0; i < dt_SearchComplainCirciuits.Rows.Count; i++)
{
DropDownList ddl1 = (DropDownList)GVTeam.Rows[i].Cells[1].FindControl("DropDownList1");
DropDownList ddl2 = (DropDownList)GVTeam.Rows[i].Cells[2].FindControl("DropDownList2");
FillDropDownList(ddl2);
FillDropDownList2(ddl1);
}
}
private void SearchComplainCircuits()
{
try
{
int Sign = 0;
DeptID = Convert.ToInt16(Session["DepartmentID"]);
if (tbSignupID.Text != string.Empty)
{
Sign = Convert.ToInt32(tbSignupID.Text);
}
else
{
Sign = 0;
}
int SearchFollow = 0;
string Format = null;
if (cbQCFormat.Checked == true)
{
Format = "QC";
}
else if (cbSDFormat.Checked == true)
{
Format = "SD";
}
else
{
Format = "";
}
DataTable dt = objBSS.SearchComplainCircuits(tbTicketNumber.Text,
Sign, tbCMSID.Text, tbGPID.Text, tbCircuitName.Text,
(cmbTicketType.Text != "Select Ticket Type" ? cmbTicketType.Text : ""),
Convert.ToInt16(cmbComplainStatus.SelectedValue),
Convert.ToInt16(cmbCity.SelectedValue),
Convert.ToInt16(cmbCircuitOwner.SelectedValue),
(cmbLoggedBy.Text != "Select LoggedBy" ? cmbLoggedBy.Text : ""),
Convert.ToInt16(cmbCaseCategory.SelectedValue),
Convert.ToInt16(cmbInitialStatement.SelectedValue),
Convert.ToInt16(cmbProblemDiagnosedAt.SelectedValue),
Convert.ToInt16(cmbReasonofOutage.SelectedValue),
dtToDate.SelectedDate.Value, dtFromDate.SelectedDate.Value,
Convert.ToInt16(cmbCustomerCode.SelectedValue),
Convert.ToInt16(cmbCurrentDepartment.SelectedValue),
Convert.ToInt16(cmbNode.SelectedValue), 4,
Format, SearchFollow, Convert.ToInt16(cmbReportedVia.SelectedValue),
Convert.ToInt16(cmbForwardToDepartment.SelectedValue),
Convert.ToInt16(cmbForwardByDepartment.SelectedValue),
Convert.ToInt16(cmbForwardStatus.SelectedValue));
lblTotalCount.Text = Convert.ToString(dt.Rows.Count);
lblTotalCount.Visible = true;
if (dt.Rows.Count > 0)
{
gvComplainCircuits.DataSource = dt;
gvComplainCircuits.DataBind();
if (DeptID == 1 || DeptID == 15)
{
//gvComplainCircuits.MasterTableView.GetColumn("ComplainClosuer").Display = true;
//gvComplainCircuits.MasterTableView.GetColumn("col_followHis").Display = true;
gvComplainCircuits.MasterTableView.GetColumn("ComplainClosuer").Display = true;
//gvComplainCircuits.MasterTableView.GetColumn("TicketNo").Display = false;
}
else
{
gvComplainCircuits.MasterTableView.GetColumn("ComplainClosuer").Display = false;
}
//gvComplainCircuits.MasterTableView.GetColumn("TicketNo").Display = false;
gvComplainCircuits.MasterTableView.GetColumn("ComplaintID").Display = false;
gvComplainCircuits.MasterTableView.GetColumn("NodeID").Display = false;
gvComplainCircuits.MasterTableView.GetColumn("ComplaintStatusID").Display = false;
gvComplainCircuits.MasterTableView.GetColumn("colfollow").Display = true;
gvComplainCircuits.MasterTableView.GetColumn("colSolve").Display = true;
gvComplainCircuits.MasterTableView.GetColumn("colViewHistory").Display = true;
gvComplainCircuits.MasterTableView.GetColumn("InfraID").Display = false;
//ChangeToButtonColumn("SignupID", 6);
//ChangeToButtonColumn("TicketNo", 7);
}
else
{
//lblTotalCount.Text = "0";
gvComplainCircuits.DataSource = null;
gvComplainCircuits.DataBind();
//Interaction.MsgBox("No Record Found", MsgBoxStyle.Information, "BSS Administrator");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void SetInitialRow()
{
int SignupID = 0;
int City = 0;
int node = 0;
string team = "";
if (txtSignUpID.Text != "")
{
SignupID = Convert.ToInt32(txtSignUpID.Text);
}
if (cmbCity.SelectedValue != "0")
{
City = Convert.ToInt32(cmbCity.SelectedValue);
}
if (cmbNode.SelectedValue != "0")
{
node = Convert.ToInt32(cmbNode.SelectedValue);
}
System.DateTime sysdate = DateTime.MinValue;
DataTable dt_SearchComplainCirciuits = objBSS.SearchComplainCircuits("", SignupID, "", "", "", "", 4, City, 0, "", 0, 0, 0, 0, sysdate, sysdate, 0, Convert.ToInt32(Session["DepartmentID"]), node, 0, "OM", 0, 0, 0, 0, 0);
DataTable DTTeam = objBSS.GetTeamList();
GVTeam.DataSource = dt_SearchComplainCirciuits;
GVTeam.DataBind();
//Store the DataTable in ViewState for future reference
ViewState["CurrentTable"] = dt_SearchComplainCirciuits;
//Bind the Gridview
GVTeam.DataSource = dt_SearchComplainCirciuits;
GVTeam.DataBind();
dtForExcel = new DataTable();
dtForExcel = dt_SearchComplainCirciuits;
//After binding the gridview, we can then extract and fill the DropDownList with Data
for (int i = 0; i < dt_SearchComplainCirciuits.Rows.Count; i++)
{
DropDownList ddl1 = (DropDownList)GVTeam.Rows[i].Cells[1].FindControl("DropDownList1");
DropDownList ddl2 = (DropDownList)GVTeam.Rows[i].Cells[2].FindControl("DropDownList2");
FillDropDownList(ddl2);
FillDropDownList2(ddl1);
if (dt_SearchComplainCirciuits.Rows[i]["TeamName"].ToString() != "N/A")
{
foreach (DataRow row in DTTeam.Rows)
{
if (row["TeamName"].ToString() == dt_SearchComplainCirciuits.Rows[i]["TeamName"].ToString())
{
team = row["TeamID"].ToString();
}
}
ddl1.SelectedValue = team;
ddl2.SelectedValue = dt_SearchComplainCirciuits.Rows[i]["Priority"].ToString();
}
}
}
