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()
{
return(From_Date.ToString("MM/dd/yyy").PadRight(15) + To_Date.ToString("MM/dd/yyy").PadRight(15) + Site_Id.ToString().PadRight(10) + Reservation_Id.ToString().PadRight(15) + Name.PadRight(30));
}
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;
}
}
// FOR ACTIVE RECEIPTS
public List <Remit_ReceiptRepo> GetERList(Remit_ReceiptRepo ReceiptRepo)
{
try
{
AppSettings app = new AppSettings();
con = app.GetConnection();
List <Remit_ReceiptRepo> bn = new List <Remit_ReceiptRepo>();
string query = "Select * from VW_RECEIPT_EMPLOYER WHERE EMPLOYER_ID = '" + Employer_Id + "' and (ACTUAL_RECEIPT_DATE between '" + From_Date.ToString("dd-MMM-yyyy") + "' and '" + To_Date.ToString("dd-MMM-yyyy") + "') AND RECEIPT_STATUS = 'ACTIVE'";
return(bn = con.Query <Remit_ReceiptRepo>(query).ToList());
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Dispose();
}
}
public override string ToString()
{
return(Reservation_ID.ToString() + Site_ID.ToString() + Name + From_Date.ToString() + To_Date.ToString() + Create_Date.ToString());
}
private static void StartProcess()
{
if (setup[25] == "Y")
{
//Delete Old DB
LocalDBconn = new SqlConnection(LocalDB);
int BackDays = Convert.ToInt32(setup[26]);
BackDays = BackDays * -1;
LocalDBconn.Open();
from = DateTime.Today.AddDays(BackDays).ToString("M/d/yyyy HH:mm:ss");
string FlowDel = "DELETE FROM dataExportEwp WHERE datetime <= '" + from + "'";
string PresDel = "DELETE FROM datapoints WHERE DataTime <='" + from + "'";
Console.WriteLine("Deleting DB Data before to Date : " + from);
Console.WriteLine("--------------------------------------------------");
SqlCommand DelFlw = new SqlCommand(FlowDel, LocalDBconn);
DelFlw.ExecuteNonQuery();
SqlCommand DelPres = new SqlCommand(PresDel, LocalDBconn);
DelPres.ExecuteNonQuery();
if (File.Exists(logpath))
{
using (var tw = new StreamWriter(logpath, true))
{
tw.WriteLine("Deleting DB Data before to Date :" + from);
tw.WriteLine("\n");
tw.WriteLine("--------------------------------------------------");
}
}
else
{
//File.CreateText(logpath);
File.WriteAllText(logpath, "");
using (var tw = new StreamWriter(logpath, true))
{
tw.WriteLine("Deleting DB Data before to Date : " + from);
tw.WriteLine("\n");
tw.WriteLine("--------------------------------------------------");
}
}
LocalDBconn.Close();
}
else
{
if (File.Exists(logpath))
{
using (var tw = new StreamWriter(logpath, true))
{
tw.WriteLine("Deleting DB Data : DISABLED");
tw.WriteLine("\n");
tw.WriteLine("--------------------------------------------------");
}
}
else
{
//File.CreateText(logpath);
File.WriteAllText(logpath, "");
using (var tw = new StreamWriter(logpath, true))
{
tw.WriteLine("Deleting DB Data : DISABLED");
tw.WriteLine("\n");
tw.WriteLine("--------------------------------------------------");
}
}
}
if (setup[9] == "A")
{
typeprocess = "A";
int dt = Convert.ToInt32(setup[21]);
dt = dt * -1;
//From_Date = DateTime.Today.AddDays(-91);
//To_Date = DateTime.Today.AddDays(-90);
if (setup[23].ToString() == "24")
{
int correctHr = Convert.ToInt32(setup[24]);
correctHr = correctHr * -1;
From_Date = DateTime.Now.AddDays(dt).AddHours(correctHr);
From_Date = From_Date.AddMinutes(-From_Date.Minute);
From_Date = From_Date.AddSeconds(-From_Date.Second);
To_Date = DateTime.Now.AddDays(dt + 1).AddHours(correctHr);
//To_Date = DateTime.Now.AddHours(correctHr);
To_Date = To_Date.AddMinutes(-To_Date.Minute);
To_Date = To_Date.AddSeconds(-To_Date.Second);
}
else if (setup[23].ToString() == "DAY")
{
From_Date = DateTime.Today.AddDays(dt);
//To_Date = DateTime.Now.AddDays(dt + 1);
To_Date = DateTime.Today;
}
Console.WriteLine("Trigger Auto from " + From_Date + " To " + To_Date);
Console.WriteLine("--------------------------------------------------");
if (File.Exists(logpath))
{
using (var tw = new StreamWriter(logpath, true))
{
tw.WriteLine("Trigger Auto from " + From_Date + " To " + To_Date);
tw.WriteLine("\n");
tw.WriteLine("--------------------------------------------------");
}
}
else
{
File.WriteAllText(logpath, "");
using (var tw = new StreamWriter(logpath, true))
{
tw.WriteLine("Trigger Auto from " + From_Date + " To " + To_Date);
tw.WriteLine("\n");
tw.WriteLine("--------------------------------------------------");
}
}
}
else if (setup[9] == "M")
{
typeprocess = "M";
}
Object FromDate = From_Date;
Object ToDate = To_Date;
Object Type = typeprocess;
starttoconvert(From_Date, To_Date, typeprocess);
}
