protected void Button1_Click(object sender, EventArgs e)
{
int cnt2 = updatedatadesc.getcount();
if (cnt2 == 0)
{
LinkButton1.Visible = false;
int j = DUPLICATEBL.chkempty();
if (j == 1)
{
string userid = Session["uname"].ToString();
int i = metadatasavebl.updateverification(userid);
if (i == 1)
{
Session["clr"] = "2";
Response.Redirect("verifydata.aspx");
//jscall("Data Verified");
}
}
else
{
jscall("No data for verification. First Prepare Data");
}
}
else
{
LinkButton1.Visible = true;
LinkButton1.Text = "Please update description first";
LinkButton1.PostBackUrl = "updatedesclist.aspx";
jscall1("update description first");
}
}
protected void LinkButton10_Click(object sender, EventArgs e)
{
// Response.Redirect("adminlogin.aspx");
int i = DUPLICATEBL.chkempty();
if (i == 1)
{
int j = DUPLICATEBL.chkverfied();
if (j == 1)
{
int k = DUPLICATEBL.chkuser();
if (k < 1)
{
lbllogin.Text = "Enter Administrator's userid password for accessing data";
}
popup.Show();
txtuser.Text = " ";
txtuser.Focus();
}
else
{
jscall1("First Verify Data");
}
}
else
{
jscall1("No data for uploading first prepare it");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
int i = DUPLICATEBL.chkempty();
if (i == 1)
{
int j = DUPLICATEBL.chkverfied();
if (j != 1)
{
popup.Show();
}
else
{
jscall("Data is already verified");
}
}
else
{
jscall("No Data For cancellation");
}
//DUPLICATEBL.clearall();
//jscall("Data Cleared. Again Prepare Data");
}
protected void btnprepare_Click(object sender, EventArgs e)
{
Page.Validate();
if (Page.IsValid == true)
{
int i = DUPLICATEBL.chkempty();//function for cheking that temp database is empty or not
//if (i == 1)
if (i >= 0)
{
FileName = System.IO.Path.GetFileNameWithoutExtension(FileUpload1.PostedFile.FileName);
if ((FileUpload1.PostedFile != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
FileName = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
SaveLocation = Server.MapPath("~/Upload") + " \\" + FileName;
if (File.Exists(SaveLocation))
{
//try
//{
// //File.Delete(SaveLocation);
//}
//catch (Exception exc)
//{
// // jscall("File is in use" + exc.Message.ToString());
//}
//finally
//{
// System.Diagnostics.Process[] wordInstances = System.Diagnostics.Process.GetProcessesByName("WINWORD");
// foreach (System.Diagnostics.Process wordInstance in wordInstances)
// {
// wordInstance.Kill();
// }
//}
}
try
{
FileUpload1.PostedFile.SaveAs(SaveLocation);
}
catch (Exception ex)
{
throw ex;
}
}
SaveLocation = Server.MapPath("~/Upload") + "\\" + FileName;
//string path1 = Server.MapPath("~/Upload") + "\\" + "data for WEB Site.mdb";
filechk = DUPLICATEBL.chkfile(SaveLocation);
ViewState["filechk"] = filechk;
if (filechk == 0)
{
chk = DUPLICATEBL.chknewentry(SaveLocation, ddltype.SelectedValue);
}
chk = 1;
if (chk > 0)
{
popup.Show();
}
else
{
startprepare();
jscall("Data Prepared Successfully");
}
}
else
{
jscall("first Upload Previous data");
}
}
else
{
jscall1("check validations");
}
#region unwanted code
// cmd.Connection = conn;
// cmd.CommandText = "select REALSTAT,STATNAME,COUNTRY,PROVINCE,SUBDISTRICT,BASIN,RIVERNAME,TRIBUTARY,CATCH,LATITUDE,LONGITUDE,ALTITUDE,CATAREA,TOPOSHEET,AGENCY,REGOFFICE,CIRCOFFICE,DIVOFFICE,SUBDIVOFFICE,SECTOFFICE,REMARKS,OWNERAGENCY,STARTDATE,ENDDATE,LOCALXCOORD,LOCALYCOORD from "+filename1 +".Location";
// int i = (int)cmd.ExecuteScalar();
//OleDbDataReader rdr=null;
// rdr = cmd.ExecuteReader();
// while (rdr.Read())
// {
// SqlConnection sqlcon = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and Settings\\Administrator\\Desktop\\Hydro project\\App_Data\\Hydro.mdf;Integrated Security=True;User Instance=True");
// sqlcon.Open();
// SqlCommand cmd1 = new SqlCommand("insert into Location( REALSTAT,STATNAME,COUNTRY,PROVINCE,SUBDISTRICT) values ('"+ rdr[0].ToString() + "','" + rdr[1].ToString() + "','" + rdr[2].ToString() + "','" + rdr[3].ToString() + "','" + rdr[4].ToString() + "' ) ", sqlcon);
// cmd1.ExecuteNonQuery();
// }
// rdr.Close();
// string a = conn.Database;
// //dbConn.Open();
// SqlConnection consql = new SqlConnection(DBConnection);
// SqlCommand cmdsql = new SqlCommand();
// consql.Open();
// cmdsql.Connection = consql;
// string b = consql.Database;
// cmdsql.CommandText = "insert into HYDRO.Location ( REALSTAT,STATNAME,COUNTRY,PROVINCE,SUBDISTRICT,BASIN,RIVERNAME,TRIBUTARY,CATCH,LATITUDE,LONGITUDE,ALTITUDE,CATAREA,TOPOSHEET,AGENCY,REGOFFICE,CIRCOFFICE,DIVOFFICE,SUBDIVOFFICE,SECTOFFICE,REMARKS,OWNERAGENCY,STARTDATE,ENDDATE,LOCALXCOORD,LOCALYCOORD) select REALSTAT,STATNAME,COUNTRY,PROVINCE,SUBDISTRICT,BASIN,RIVERNAME,TRIBUTARY,CATCH,LATITUDE,LONGITUDE,ALTITUDE,CATAREA,TOPOSHEET,AGENCY,REGOFFICE,CIRCOFFICE,DIVOFFICE,SUBDIVOFFICE,SECTOFFICE,REMARKS,OWNERAGENCY,STARTDATE,ENDDATE,LOCALXCOORD,LOCALYCOORD from " + a+".Location";
//// cmdsql.CommandText="insert Location( REALSTAT,STATNAME,COUNTRY,PROVINCE,SUBDISTRICT,BASIN,RIVERNAME,TRIBUTARY,CATCH,LATITUDE,LONGITUDE,ALTITUDE,CATAREA,TOPOSHEET,AGENCY,REGOFFICE,CIRCOFFICE,DIVOFFICE,SUBDIVOFFICE,SECTOFFICE,REMARKS,OWNERAGENCY,STARTDATE,ENDDATE,LOCALXCOORD,LOCALYCOORD) select (REALSTAT,STATNAME,COUNTRY,PROVINCE,SUBDISTRICT,BASIN,RIVERNAME,TRIBUTARY,CATCH,LATITUDE,LONGITUDE,ALTITUDE,CATAREA,TOPOSHEET,AGENCY,REGOFFICE,CIRCOFFICE,DIVOFFICE,SUBDIVOFFICE,SECTOFFICE,REMARKS,OWNERAGENCY,STARTDATE,ENDDATE,LOCALXCOORD,LOCALYCOORD) from "+filename1+".Location";
// cmdsql.ExecuteNonQuery();
//cmdsql.CommandText = "select count(*) from Location";
//int i = (int)cmdsql.ExecuteScalar();
//conn.Close();
#endregion
}
