protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
clsCommon cl = new clsCommon();
string RodName = cl.GetRodName(HttpContext.Current);
string EpebType = cl.GetEpebType(HttpContext.Current);
string EpebNo = cl.GetEpebNo(HttpContext.Current);
if (RodName == "" || EpebType == "" || EpebNo == "")
{
LblNoData.Text = "Your session has expired, please try again!";
LblNoData.Visible = true;
imgProcess.Visible = false;
lblPrint.Visible = false;
btnprint.Visible = false;
return;
}
if (RodName == null || EpebType == null || EpebNo == null)
{
LblNoData.Text = "Your session has expired, please try again!";
LblNoData.Visible = true;
imgProcess.Visible = false;
lblPrint.Visible = false;
btnprint.Visible = false;
return;
}
string path = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["Path"].ToString());
string strTextFile = System.Configuration.ConfigurationManager.AppSettings["txtFileName"].ToString();
string RodId = cl.GetRodId(HttpContext.Current);
if (clsCommon.GetInfo4XML(path, strTextFile, RodId) == true)
{
}
else
{
LblNoData.Text = "Data for selected Registry of deeds is not available, please try later!";
LblNoData.Visible = true;
imgProcess.Visible = false;
lblPrint.Visible = false;
btnprint.Visible = false;
return;
}
switch (EpebType)
{
case "CCV":
imgProcess.ImageUrl = "~/LRA_Images/CCV.JPG";
//imgProcess.Height = 100;
break;
case "Chattel Mortgage":
imgProcess.ImageUrl = "~/LRA_Images/CM.JPG";
break;
case "Personal Properties":
imgProcess.ImageUrl = "~/LRA_Images/PP.JPG";
break;
case "Provisional Registration":
imgProcess.ImageUrl = "~/LRA_Images/RL.JPG";
break;
case "Registered Land":
imgProcess.ImageUrl = "~/LRA_Images/RL.JPG";
break;
case "Unregistered Land":
imgProcess.ImageUrl = "~/LRA_Images/UL.JPG";
break;
case "CARP Book":
imgProcess.ImageUrl = "~/LRA_Images/RL_CARP.JPG";
break;
}
try
{
DataSet ds = new DataSet();//this dataset to read XML to datagrid
string fileLocation = cl.GetNewPath(HttpContext.Current);
Session["tableF"] = null;
if (fileLocation == "" || fileLocation == null)
{
LblNoData.Text = "Unable to get information, please try after sometime!";
LblNoData.Visible = true;
btnprint.Visible = false;
imgProcess.Visible = false;
lblPrint.Visible = false;
btnprint.Visible = false;
return;
}
//string fileName = fileLocation + "\\TransactionStatus.xml";
string fileName = fileLocation + "\\" + RodId + ".xml";
XPathDocument doc = new XPathDocument(fileName);
XPathNavigator nav = doc.CreateNavigator();
// Compile a standard XPath expression
XPathExpression expr;
expr = nav.Compile("/NewDataSet/Table[RoD_Name='" + RodName + "']|/NewDataSet/Table[EPEB_Type_Desc='" + EpebType + "']|/NewDataSet/Table[EPEB_ENO='" + EpebNo + "']");
XPathNodeIterator iterator = nav.Select(expr);
try
{
if (iterator.Count > 0)
{
while (iterator.MoveNext())
{
XPathNavigator nav2 = iterator.Current.Clone();
nav2.MoveToFirstChild();
string a = nav2.Value;
nav2.MoveToNext();
string b = nav2.Value;
nav2.MoveToNext();
string c = nav2.Value;
nav2.MoveToNext();
string d = nav2.Value;
if (a == RodName && b == EpebType && c == EpebNo)
{
IFormatter formatter = new BinaryFormatter();
DataTable table = new DataTable();
//byte[] bt = Encoding.ASCII.GetBytes(iterator.Current.OuterXml);
//MemoryStream ms = new MemoryStream();
//formatter.Serialize(ms, iterator.Current.OuterXml);
StringReader stream = new StringReader(iterator.Current.OuterXml);
XmlTextReader reader = new XmlTextReader(stream);
ds.ReadXml(reader);
//ds.ReadXml(ms);
GridView1.DataSource = ds;
Session["tableF"] = ds.Tables[0];
GridView1.DataBind();
#region Added Riyaz
/* This Code Added in 04/07/2011 because of CRF_OTM_02_01 */
if (ds.Tables[0].Rows[0]["Activity_ID"].ToString().ToUpper() == "CLOSED")
{
GridView1.HeaderRow.Cells[5].Text = "Closed Date";
}
else if (ds.Tables[0].Rows[0]["Activity_ID"].ToString().ToUpper() == "WITHDRAWN")
{
GridView1.HeaderRow.Cells[5].Text = "Withdrawn Date";
}
else if (ds.Tables[0].Rows[0]["Activity_ID"].ToString().ToUpper() == "VOIDED")
{
GridView1.HeaderRow.Cells[5].Text = "Voided Date";
}
else
{
GridView1.Columns[5].Visible = false;
}
#endregion
GridView1.Visible = true;
PnlGrid.Visible = true;
//FileAttributes fileAttributes = File.GetAttributes(fileLocation + "\\TransactionStatus.xml");
//FileInfo f = new FileInfo(fileLocation + "\\TransactionStatus.xml");
//FileAttributes fileAttributes = File.GetAttributes(fileLocation + "\\" + RodId + ".xml");
//FileInfo f = new FileInfo(fileLocation + "\\" + RodId + ".xml");
//Lbldate.Text = f.LastWriteTime.ToLongDateString().Trim();
//LblTime.Text = f.LastWriteTime.ToShortTimeString().Trim();
DataSet ds1 = new DataSet();
ds1.ReadXml(fileLocation + "\\ExtractTime.xml");
Lbldate.Text = ds1.Tables[0].Rows[0][0].ToString().Trim();
Lbldate.Visible = true;
LblTime.Visible = false;
Lblcreatedate.Visible = true;
//Label1.Visible = true;
btnprint.Visible = true;
LblNoData.Visible = false;
imgProcess.Visible = true;
lblPrint.Visible = true;
break;
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
LblNoData.Text = "Data Not Available. Please Check your entry!";
LblNoData.Visible = true;
imgProcess.Visible = false;
Lbldate.Visible = false;
LblTime.Visible = false;
Lblcreatedate.Visible = false;
//Label1.Visible = false;
btnprint.Visible = false;
lblPrint.Visible = false;
}
}
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
LblNoData.Text = "Data Not Available. Please Check your entry!";
LblNoData.Visible = true;
imgProcess.Visible = false;
Lbldate.Visible = false;
LblTime.Visible = false;
Lblcreatedate.Visible = false;
//Label1.Visible = false;
btnprint.Visible = false;
lblPrint.Visible = false;
}
}
catch
{
LblNoData.Text = "Unable to show data, please try after sometime!";
btnprint.Visible = false;
imgProcess.Visible = false;
LblNoData.Visible = true;
imgProcess.Visible = false;
lblPrint.Visible = false;
}
#region reading xml file by ReadXML --- not in use due to performance issue
//ds.ReadXml(Server.MapPath("~\\XML\\TransactionStatus.xml"));
//ds.ReadXml(fileLocation + "\\TransactionStatus.xml");
//try
//{
// DataRow[] rows = ds.Tables[0].Select("RoD_Name = '" + RodName + "' and EPEB_Type_Desc = '" + EpebType + "' and EPEB_ENO = '" + EpebNo + "'");
// if (rows.Length > 0)
// {
// imgProcess.Visible = true;
// LblNoData.Visible = false;
// DataTable table = new DataTable();
// table = ds.Tables[0].Clone();
// DataRow row = table.NewRow();
// foreach (DataRow r in rows)
// {
// row["RoD_Name"] = r["RoD_Name"];
// row["EPEB_Type_Desc"] = r["EPEB_Type_Desc"];
// row["EPEB_ENO"] = r["EPEB_ENO"];
// row["Activity_ID"] = r["Activity_ID"];
// table.Rows.Add(row);
// }
// GridView1.DataSource = table;
// Session["tableF"]=table;
// GridView1.DataBind();
// GridView1.Visible = true;
// PnlGrid.Visible = true;
// FileAttributes fileAttributes = File.GetAttributes(fileLocation + "\\TransactionStatus.xml");
// FileInfo f = new FileInfo(fileLocation + "\\TransactionStatus.xml");
// Lbldate.Text = f.LastWriteTime.ToLongDateString().Trim();
// LblTime.Text = f.LastWriteTime.ToLongTimeString().Trim();
// Lbldate.Visible = true;
// LblTime.Visible = true;
// Lblcreatedate.Visible = true;
// Label1.Visible = true;
// }
// else
// {
// GridView1.DataSource = null;
// GridView1.DataBind();
// LblNoData.Text = "Data Not Available. Please Check your entry!";
// LblNoData.Visible = true;
// imgProcess.Visible = false;
// Lbldate.Visible = false;
// LblTime.Visible = false;
// Lblcreatedate.Visible = false;
// Label1.Visible = false;
// }
//}
//catch
//{
// LblNoData.Text = "Unable to show data, please try after sometime!";
// LblNoData.Visible = true;
// imgProcess.Visible = false;
//}
#endregion
}
catch
{
LblNoData.Text = "Unable to retrive data, please try after sometime!";
btnprint.Visible = false;
imgProcess.Visible = false;
LblNoData.Visible = true;
imgProcess.Visible = false;
}
}
}