public List<XObjs.Office_view> getNew_MarkInfoRSX7(string status, string data_status, string pvalidation, int start, int limit)
{
SqlCommand command;
List<XObjs.Office_view> list = new List<XObjs.Office_view>();
new XObjs.Office_view();
SqlConnection connection = new SqlConnection(this.Connect2());
// command = new SqlCommand(string.Concat(new object[] { "select pwallet.rtm,pwallet.ID,pwallet.TransactionId,pwallet.visible,pwallet.applicantID,pwallet.applicantID,applicant.xname,address_service.street ,address_service.telephone1,address_service.email1,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID LEFT OUTER JOIN address_service ON address_service.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status>='", status, "' AND pwallet.data_status='", data_status, "' and mark_info.reg_number ='", pvalidation, "' order by pwallet.rtm DESC " }), connection);
command = new SqlCommand(string.Concat(new object[] { "select pwallet.rtm,pwallet.ID,pwallet.TransactionId,pwallet.visible,pwallet.applicantID,pwallet.applicantID,applicant.xname,address.street ,address.telephone1,address.email1,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID LEFT OUTER JOIN address ON address.ID=applicant.addressID WHERE pwallet.stage='5' AND pwallet.data_status in ('Certified','Accepted','Opposed','Deferred','Published','kiv','Migrated','New','Registered','Not Opposed', 'Search 2 Conducted', 'Search Conducted') and mark_info.reg_number ='", pvalidation, "' order by pwallet.rtm DESC " }), connection);
// }
// command.CommandTimeout = 0;
connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
string pp2 = "";
int vcount = 0;
int vsn = 0;
string voffice = "";
while (reader.Read())
{
vsn = vsn + 1;
vcount = vcount + 1;
XObjs.Registration pdd = getRegistrationBySubagentRegistrationID(reader["applicantID"].ToString());
//if (getTmOfficeByMID(reader["log_staff"].ToString()) != "")
//{
// voffice = (getTmOfficeByMID(reader["log_staff"].ToString()));
//}
//else
//{
// voffice = "None";
//}
XObjs.Office_view item = new XObjs.Office_view
{
xid = reader["xID"].ToString(),
id = reader["ID"].ToString(),
rtm = reader["rtm"].ToString(),
applicant_name = reader["xname"].ToString(),
xclass = reader["class"].ToString(),
reg_no = reader["reg_no"].ToString(),
tm_type = reader["tm_type"].ToString(),
product_title = reader["product_title"].ToString(),
oai_no = reader["oai_no"].ToString(),
xstat = reader["xstat"].ToString(),
reg_dt = reader["reg_dt"].ToString(),
log_staff = reader["log_staff"].ToString(),
// batches = reader["visible"].ToString(),
applicantID = reader["applicantID"].ToString(),
//Office = reader["data_status"].ToString(),
Sn = Convert.ToString(vsn),
Agent_Code = pdd.Sys_ID,
Agent_Name = pdd.Surname,
TransactionId = reader["TransactionId"].ToString(),
Xaddress = reader["street"].ToString(),
Xemail = reader["email1"].ToString(),
Xmobile = reader["telephone1"].ToString()
};
try
{
int dw = Convert.ToInt32(reader["visible"]);
if (dw > 1)
{
pp2 = (Convert.ToInt32(reader["visible"]) - 1).ToString();
}
else
{
pp2 = (Convert.ToInt32(reader["visible"])).ToString();
}
}
catch (Exception ee)
{
}
item.batches = pp2;
list.Add(item);
}
reader.Close();
connection.Close();
return list;
}
public List<XObjs.Office_view> getNew_MarkInfoRSX4(string pvalidation)
{
SqlCommand command;
List<XObjs.Office_view> list = new List<XObjs.Office_view>();
new XObjs.Office_view();
SqlConnection connection = new SqlConnection(this.Connect2());
command = new SqlCommand(string.Concat(new object[] { "select g_tm_info.tm_title 'tm_title',g_pwallet.ID,g_tm_info.tm_class 'xclass',g_applicant_info.xname,g_applicant_info.address,g_applicant_info.xemail,g_applicant_info.xmobile, g_pwallet.log_officer,g_pwallet.validationID ,g_pwallet.applicantID,g_pwallet.TransactionId,g_tm_info.reg_number,g_tm_info.xID,g_app_info.rtm_number,g_app_info.application_no,g_app_info.item_code,g_app_info.filing_date,g_app_info.reg_no, g_app_info.reg_date,g_app_info.log_staff,g_app_info.visible,g_applicant_info.xname from g_app_info LEFT OUTER JOIN g_tm_info ON g_app_info.log_staff=g_tm_info.log_staff LEFT OUTER JOIN g_pwallet ON g_app_info.log_staff=g_pwallet.ID LEFT OUTER JOIN g_applicant_info on g_pwallet.id=g_applicant_info.log_staff WHERE g_app_info.rtm_number ='", pvalidation, "' " }), connection); ;
// g_app_info.reg_date,g_app_info.log_staff,g_app_info.visible from g_app_info LEFT OUTER JOIN g_tm_info ON g_app_info.log_staff=g_tm_info.log_staff
// }
// command.CommandTimeout = 0;
connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
string pp2 = "";
int vcount = 0;
int vsn = 0;
string voffice = "";
while (reader.Read())
{
vsn = vsn + 1;
vcount = vcount + 1;
XObjs.Registration pdd = getRegistrationBySubagentRegistrationID(reader["applicantID"].ToString());
//if (getTmOfficeByMID(reader["log_staff"].ToString()) != "")
//{
// voffice = (getTmOfficeByMID(reader["log_staff"].ToString()));
//}
//else
//{
// voffice = "None";
//}
XObjs.Office_view item = new XObjs.Office_view
{
xid = reader["xID"].ToString(),
rtm = reader["rtm_number"].ToString(),
applicant_name = reader["xname"].ToString(),
Xaddress = reader["address"].ToString(),
Xemail = reader["xemail"].ToString(),
Xmobile = reader["xmobile"].ToString(),
xclass = reader["xclass"].ToString(),
reg_no = reader["application_no"].ToString(),
// tm_type = reader["tm_type"].ToString(),
product_title = reader["tm_title"].ToString(),
oai_no = reader["validationID"].ToString(),
// xstat = reader["xstat"].ToString(),
reg_dt = reader["reg_date"].ToString(),
log_staff = reader["log_staff"].ToString(),
// batches = reader["visible"].ToString(),
applicantID = reader["applicantID"].ToString(),
//Office = reader["data_status"].ToString(),
Sn = Convert.ToString(vsn),
Agent_Code = pdd.Sys_ID,
Agent_Name = pdd.Surname,
TransactionId = reader["TransactionId"].ToString(),
id = reader["ID"].ToString()
};
try
{
int dw = Convert.ToInt32(reader["visible"]);
if (dw > 1)
{
pp2 = (Convert.ToInt32(reader["visible"]) - 1).ToString();
}
else
{
pp2 = (Convert.ToInt32(reader["visible"])).ToString();
}
}
catch (Exception ee)
{
}
item.batches = pp2;
list.Add(item);
}
reader.Close();
connection.Close();
return list;
}
public List<XObjs.Office_view> getNew_MarkInfoRSX5(string pvalidation)
{
SqlCommand command;
List<XObjs.Office_view> list = new List<XObjs.Office_view>();
new XObjs.Office_view();
SqlConnection connection = new SqlConnection(this.Connect2());
//if ((status == "4") && (data_status == "Refused"))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status='", status, "' AND pwallet.data_status='", data_status, "')SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else if ((status == "4") && ((data_status == "Registrable") || (data_status == "Non-registrable")))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status='", status, "' AND ((pwallet.data_status='Non-registrable') OR (pwallet.data_status='Registrable')) )SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else if ((status == "1") && ((data_status == "Fresh") || (data_status == "Invalid")))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status='", status, "' AND (pwallet.data_status='Fresh' OR pwallet.data_status='Invalid') )SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else if ((status == "8") && (data_status == "Registered"))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status>'", status, "' AND pwallet.data_status='", data_status, "' )SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else if ((status == "5") && (data_status == "acc_printed"))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.acc_p='1' )SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else
//{
//command = new SqlCommand(string.Concat(new object[] { "select pwallet.rtm,pwallet.TransactionId,pwallet.visible,pwallet.applicantID,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status>='", status, "' AND pwallet.data_status='", data_status, "' and pwallet.validationID ='", pvalidation, "' order by pwallet.rtm DESC " }), connection);
command = new SqlCommand(string.Concat(new object[] { "select g_tm_info.tm_title 'tm_title',g_pwallet.ID,g_tm_info.tm_class 'xclass',g_applicant_info.xname,g_applicant_info.address,g_applicant_info.xemail,g_applicant_info.xmobile, g_pwallet.log_officer,g_pwallet.validationID ,g_pwallet.applicantID,g_pwallet.TransactionId,g_tm_info.reg_number,g_tm_info.xID,g_app_info.rtm_number,g_app_info.application_no,g_app_info.item_code,g_app_info.filing_date,g_app_info.reg_no, g_app_info.reg_date,g_app_info.log_staff,g_app_info.visible,g_applicant_info.xname from g_app_info LEFT OUTER JOIN g_tm_info ON g_app_info.log_staff=g_tm_info.log_staff LEFT OUTER JOIN g_pwallet ON g_app_info.log_staff=g_pwallet.ID LEFT OUTER JOIN g_applicant_info on g_pwallet.id=g_applicant_info.log_staff WHERE g_app_info.application_no ='", pvalidation, "' " }), connection); ;
// g_app_info.reg_date,g_app_info.log_staff,g_app_info.visible from g_app_info LEFT OUTER JOIN g_tm_info ON g_app_info.log_staff=g_tm_info.log_staff
// }
// command.CommandTimeout = 0;
connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
string pp2 = "";
int vcount = 0;
int vsn = 0;
string voffice = "";
while (reader.Read())
{
vsn = vsn + 1;
vcount = vcount + 1;
XObjs.Registration pdd = getRegistrationBySubagentRegistrationID(reader["applicantID"].ToString());
//if (getTmOfficeByMID(reader["log_staff"].ToString()) != "")
//{
// voffice = (getTmOfficeByMID(reader["log_staff"].ToString()));
//}
//else
//{
// voffice = "None";
//}
XObjs.Office_view item = new XObjs.Office_view
{
xid = reader["xID"].ToString(),
rtm = reader["rtm_number"].ToString(),
applicant_name = reader["xname"].ToString(),
xclass = reader["xclass"].ToString(),
reg_no = reader["application_no"].ToString(),
Xaddress = reader["address"].ToString(),
Xemail = reader["xemail"].ToString(),
Xmobile = reader["xmobile"].ToString(),
// tm_type = reader["tm_type"].ToString(),
product_title = reader["tm_title"].ToString(),
oai_no = reader["validationID"].ToString(),
// xstat = reader["xstat"].ToString(),
reg_dt = reader["reg_date"].ToString(),
log_staff = reader["log_staff"].ToString(),
// batches = reader["visible"].ToString(),
applicantID = reader["applicantID"].ToString(),
//Office = reader["data_status"].ToString(),
Sn = Convert.ToString(vsn),
Agent_Code = pdd.Sys_ID,
Agent_Name = pdd.Surname,
TransactionId = reader["TransactionId"].ToString(),
id = reader["ID"].ToString()
};
try
{
int dw = Convert.ToInt32(reader["visible"]);
if (dw > 1)
{
pp2 = (Convert.ToInt32(reader["visible"]) - 1).ToString();
}
else
{
pp2 = (Convert.ToInt32(reader["visible"])).ToString();
}
}
catch (Exception ee)
{
}
item.batches = pp2;
list.Add(item);
}
reader.Close();
connection.Close();
return list;
}
public List<XObjs.Office_view> getNew_MarkInfoRSX2(string status, string data_status, int start, int limit)
{
SqlCommand command;
List<XObjs.Office_view> list = new List<XObjs.Office_view>();
new XObjs.Office_view();
SqlConnection connection = new SqlConnection(this.Connect());
//if ((status == "4") && (data_status == "Refused"))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status='", status, "' AND pwallet.data_status='", data_status, "')SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else if ((status == "4") && ((data_status == "Registrable") || (data_status == "Non-registrable")))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status='", status, "' AND ((pwallet.data_status='Non-registrable') OR (pwallet.data_status='Registrable')) )SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else if ((status == "1") && ((data_status == "Fresh") || (data_status == "Invalid")))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status='", status, "' AND (pwallet.data_status='Fresh' OR pwallet.data_status='Invalid') )SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else if ((status == "8") && (data_status == "Registered"))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status>'", status, "' AND pwallet.data_status='", data_status, "' )SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else if ((status == "5") && (data_status == "acc_printed"))
//{
// command = new SqlCommand(string.Concat(new object[] { "WITH RSTbl AS (select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff, ROW_NUMBER() OVER (ORDER BY mark_info.xID) AS 'RowRank' from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.acc_p='1' )SELECT * FROM RSTbl WHERE RowRank BETWEEN '", start, "' AND '", limit, "' " }), connection);
//}
//else
//{
command = new SqlCommand(string.Concat(new object[] { "select pwallet.rtm,pwallet.visible,pwallet.applicantID,applicant.xname,mark_info.national_classID 'class',mark_info.xID,mark_info.reg_number 'reg_no',mark_info.product_title,tm_type.type 'tm_type',pwallet.validationID 'oai_no', ISNULL(pwallet.data_status,'None') 'xstat', mark_info.reg_date 'reg_dt',mark_info.log_staff from mark_info LEFT OUTER JOIN pwallet ON mark_info.log_staff=pwallet.ID LEFT OUTER JOIN tm_type ON tm_type.xID=mark_info.tm_typeID LEFT OUTER JOIN applicant ON applicant.log_staff=pwallet.ID WHERE pwallet.stage='5' AND pwallet.status='", status, "' AND pwallet.data_status='", data_status, "' " }), connection);
// }
// command.CommandTimeout = 0;
connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
string pp2 = "";
int vcount = 0;
int vsn = 0;
string voffice = "";
while (reader.Read())
{
vsn = vsn + 1;
vcount = vcount + 1;
//if (getTmOfficeByMID(reader["log_staff"].ToString()) != "")
//{
// voffice = (getTmOfficeByMID(reader["log_staff"].ToString()));
//}
//else
//{
// voffice = "None";
//}
XObjs.Office_view item = new XObjs.Office_view
{
xid = reader["xID"].ToString(),
rtm = reader["rtm"].ToString(),
applicant_name = reader["xname"].ToString(),
xclass = reader["class"].ToString(),
reg_no = reader["reg_no"].ToString(),
tm_type = reader["tm_type"].ToString(),
product_title = reader["product_title"].ToString(),
oai_no = reader["oai_no"].ToString(),
xstat = reader["xstat"].ToString(),
reg_dt = reader["reg_dt"].ToString(),
log_staff = reader["log_staff"].ToString(),
// batches = reader["visible"].ToString(),
applicantID = reader["visible"].ToString(),
//Office = reader["data_status"].ToString(),
Sn = Convert.ToString(vsn)
};
try
{
int dw = Convert.ToInt32(reader["visible"]);
if (dw > 1)
{
pp2 = (Convert.ToInt32(reader["visible"]) - 1).ToString();
}
else
{
pp2 = (Convert.ToInt32(reader["visible"])).ToString();
}
}
catch (Exception ee)
{
}
item.batches = pp2;
list.Add(item);
}
reader.Close();
connection.Close();
return list;
}
