protected void Get_Count_Of_Order_Type_Wise()
{
DateTime Fromdate = Convert.ToDateTime(From_date.ToString());
DateTime Todate = Convert.ToDateTime(To_Date.ToString());
string F_Date = Fromdate.ToString("MM/dd/yyyy");
string T_Date = Todate.ToString("MM/dd/yyyy");
Hashtable httargetorder = new Hashtable();
System.Data.DataTable dttargetorder = new System.Data.DataTable();
dtexport.Clear();
httargetorder.Add("@Trans", Operation_Count);
httargetorder.Add("@Clint", Client_Id);
httargetorder.Add("@Sub_Client", Sub_Process_ID);
httargetorder.Add("@F_Date", F_Date);
httargetorder.Add("@T_date", T_Date);
dttargetorder = dataaccess.ExecuteSP("Sp_Order_Status_Report", httargetorder);
if (dttargetorder.Rows.Count > 0)
{
Grid_Count.DataSource = dttargetorder;
}
else
{
Grid_Count.DataSource = null;
}
}
public override string ToString()
{
string result = string.Format("{0, 10} - {1, 10} {2, 9} {3, 30} {4, 10} {5, 25} {6, 11}",
From_date.ToShortDateString().PadRight(10), //{0}
To_date.ToShortDateString().PadRight(10), //{1}
Reservation_id.ToString().PadRight(6), //{2}
Name.PadRight(30), //{3}
Site_number.ToString().PadRight(5), //{4}
Campground.PadRight(25), //{5}
Create_date.ToShortDateString().PadRight(10)); //{6}
return(result);
}
protected void Get_Client_Wise_Production_Count_Orders_To_GridviewBind()
{
DateTime Fromdate = Convert.ToDateTime(From_date.ToString());
DateTime Todate = Convert.ToDateTime(To_Date.ToString());
Hashtable httargetorder = new Hashtable();
//System.Data.DataTable dttargetorder = new System.Data.DataTable();
dtexport.Clear();
httargetorder.Add("@Trans", Operation);
httargetorder.Add("@Clint", Client_Id);
httargetorder.Add("@Sub_Client", Sub_Process_ID);
httargetorder.Add("@Fromdate", Fromdate);
httargetorder.Add("@Todate", Todate);
dttargetorder = dataaccess.ExecuteSP("Sp_Order_Status_Report", httargetorder);
dtexport = dttargetorder;
System.Data.DataTable temptable = dttargetorder.Clone();
int startindex = currentpageindex * pagesize;
int endindex = currentpageindex * pagesize + pagesize;
if (endindex > dttargetorder.Rows.Count)
{
endindex = dttargetorder.Rows.Count;
}
for (int i = startindex; i < endindex; i++)
{
DataRow row = temptable.NewRow();
Get_Table_Row_Search(ref row, dttargetorder.Rows[i]);
temptable.Rows.Add(row);
}
if (temptable.Rows.Count > 0)
{
grd_Targetorder.DataSource = null;
grd_Targetorder.AutoGenerateColumns = false;
grd_Targetorder.ColumnCount = 18;
grd_Targetorder.Columns[0].Name = "SNo";
grd_Targetorder.Columns[0].HeaderText = "S. No";
grd_Targetorder.Columns[0].Width = 65;
//grd_Targetorder.Columns[1].Name = "Order Number";
//grd_Targetorder.Columns[1].HeaderText = "CLIENT_ORDER_NUMBER";
//grd_Targetorder.Columns[1].DataPropertyName = "Order_Number";
//grd_Targetorder.Columns[1].Width = 200;
//grd_Targetorder.Columns[1].Visible = false;
DataGridViewLinkColumn link = new DataGridViewLinkColumn();
grd_Targetorder.Columns.Add(link);
link.Name = "Order Number";
link.HeaderText = "CLIENT ORDER NUMBER";
link.DataPropertyName = "Order_Number";
link.Width = 200;
link.DisplayIndex = 1;
grd_Targetorder.Columns[1].Name = "Customer";
grd_Targetorder.Columns[1].HeaderText = "CLIENT NAME";
if (userroleid == "1")
{
grd_Targetorder.Columns[1].DataPropertyName = "Client_name";
}
else
{
grd_Targetorder.Columns[1].DataPropertyName = "Client_Number";
}
grd_Targetorder.Columns[1].Width = 140;
grd_Targetorder.Columns[2].Name = "SubProcess";
grd_Targetorder.Columns[2].HeaderText = "SUB PROCESS";
if (userroleid == "1")
{
grd_Targetorder.Columns[2].DataPropertyName = "Sub_client";
}
else
{
grd_Targetorder.Columns[2].DataPropertyName = "Subprocess_Number";
}
grd_Targetorder.Columns[2].Width = 220;
grd_Targetorder.Columns[3].Name = "Submited";
grd_Targetorder.Columns[3].HeaderText = "SUBMITTED DATE";
grd_Targetorder.Columns[3].DataPropertyName = "Date";
grd_Targetorder.Columns[3].Width = 120;
grd_Targetorder.Columns[4].Name = "OrderType";
grd_Targetorder.Columns[4].HeaderText = "ORDER TYPE";
grd_Targetorder.Columns[4].DataPropertyName = "Order_type";
grd_Targetorder.Columns[4].Width = 160;
grd_Targetorder.Columns[5].Name = "Borrower_name";
grd_Targetorder.Columns[5].HeaderText = "Borrower Name";
grd_Targetorder.Columns[5].DataPropertyName = "Borrower_Name";
grd_Targetorder.Columns[5].Width = 120;
grd_Targetorder.Columns[6].Name = "Property_Address";
grd_Targetorder.Columns[6].HeaderText = "Property Address";
grd_Targetorder.Columns[6].DataPropertyName = "Address";
grd_Targetorder.Columns[6].Width = 120;
grd_Targetorder.Columns[7].Name = "ClientOrderRef";
grd_Targetorder.Columns[7].HeaderText = "CLIENT ORDER REF. NO";
grd_Targetorder.Columns[7].DataPropertyName = "Ref_number";
grd_Targetorder.Columns[7].Width = 170;
grd_Targetorder.Columns[8].Name = "SearchType";
grd_Targetorder.Columns[8].HeaderText = "SEARCH TYPE";
grd_Targetorder.Columns[8].DataPropertyName = "County_type";
grd_Targetorder.Columns[8].Width = 160;
grd_Targetorder.Columns[9].Name = "State";
grd_Targetorder.Columns[9].HeaderText = "STATE";
grd_Targetorder.Columns[9].DataPropertyName = "State";
grd_Targetorder.Columns[9].Width = 120;
grd_Targetorder.Columns[10].Name = "County";
grd_Targetorder.Columns[10].HeaderText = "COUNTY";
grd_Targetorder.Columns[10].DataPropertyName = "County";
grd_Targetorder.Columns[10].Width = 140;
grd_Targetorder.Columns[11].Name = "Task";
grd_Targetorder.Columns[11].HeaderText = "TASK";
grd_Targetorder.Columns[11].DataPropertyName = "Current_Task";
grd_Targetorder.Columns[11].Width = 120;
grd_Targetorder.Columns[12].Name = "STATUS";
grd_Targetorder.Columns[12].HeaderText = "STATUS";
grd_Targetorder.Columns[12].DataPropertyName = "Order_Status";
grd_Targetorder.Columns[12].Width = 100;
grd_Targetorder.Columns[13].Name = "Order_ID";
grd_Targetorder.Columns[13].HeaderText = "Order_ID";
grd_Targetorder.Columns[13].DataPropertyName = "Order_ID";
grd_Targetorder.Columns[13].Width = 100;
grd_Targetorder.Columns[13].Visible = false;
grd_Targetorder.Columns[14].Name = "User";
grd_Targetorder.Columns[14].HeaderText = "User Name";
grd_Targetorder.Columns[14].DataPropertyName = "UserName";
grd_Targetorder.Columns[14].Width = 100;
grd_Targetorder.Columns[15].Name = "Comment";
grd_Targetorder.Columns[15].HeaderText = "Comments";
grd_Targetorder.Columns[15].DataPropertyName = "Comment";
grd_Targetorder.Columns[15].Width = 100;
grd_Targetorder.Columns[16].Name = "Notes";
grd_Targetorder.Columns[16].HeaderText = "Notes";
grd_Targetorder.Columns[16].DataPropertyName = "Notes";
grd_Targetorder.Columns[16].Width = 100;
grd_Targetorder.Columns[17].Name = "Production_Date";
grd_Targetorder.Columns[17].HeaderText = "Production Date";
grd_Targetorder.Columns[17].DataPropertyName = "Production_Date";
grd_Targetorder.Columns[17].Width = 100;
//grd_Targetorder.Columns[18].Name = "Recived_Order_Time";
//grd_Targetorder.Columns[18].HeaderText = "Recived Order Date";
//grd_Targetorder.Columns[18].DataPropertyName = "Recived_Order_Time";
//grd_Targetorder.Columns[18].Width = 100;
//grd_Targetorder.Columns[19].Name = "Completed_Date";
//grd_Targetorder.Columns[19].HeaderText = "Completed Date";
//grd_Targetorder.Columns[19].DataPropertyName = "Completed_Date";
//grd_Targetorder.Columns[19].Width = 100;
// grd_Targetorder.Columns[12].Visible = false;
grd_Targetorder.DataSource = temptable;
lbl_Total.Text = dttargetorder.Rows.Count.ToString();
}
else
{
grd_Targetorder.DataSource = null;
lbl_Total.Text = "0";
//grd_Targetorder.DataBind();
}
lbl_Total_Orders.Text = dttargetorder.Rows.Count.ToString();
lblRecordsStatus.Text = (currentpageindex + 1) + " / " + (int)Math.Ceiling(Convert.ToDecimal(dttargetorder.Rows.Count) / pagesize);
for (int i = 0; i < grd_Targetorder.Rows.Count; i++)
{
grd_Targetorder.Rows[i].Cells[0].Value = i + 1;
}
}