protected void ChangePasswordPushButton_Click(object sender, EventArgs e)
{
ChangePassword1.Visible = true;
ChangePassword1.Focus();
Label6.Visible = false;
Label7.Visible = false;
Label8.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
Login1.Focus();
ChangePassword1.Focus();
if (ChangePassword1.Visible == true)
{
Label7.Visible = false;
}
SIFRA = Request.QueryString["oper"];
Calendar2.TodaysDate = DateTime.Now.AddDays(0);
Calendar2.SelectedDate = Calendar2.TodaysDate;
DATUM = Calendar2.SelectedDate.ToString();
DATUM = DATUM.Substring(0, 10);
//DetailsView1.Visible = true;
//
pwdCoda = Request.QueryString["pwdCoda"];
Label1.Visible = false;
Label1.Text = pwdCoda;
// runu
Label2.Visible = false;
Label2.Text = Request.QueryString["oper"];
oper = Label2.Text;
cg = Request.QueryString["chgpwd"];
Label4.Visible = true;
if (cg != null && cg != "CERR")
{
//lChgPwd.Visible = true;
if (cg == "OK" || cg == "PWD" || cg == "EZM" || cg == "EEP")
{
if (cg == "OK")
{
Label1.Visible = false;
Label2.Visible = false;
Label3.Visible = true;
lChgPwd.Text = "Geslo je spremenjeno!";
}
else
{
lChgPwd.Text = "Zamenjaj geslo!";
lChgPwd.Visible = false;
Label3.Visible = false;
Label4.Visible = false;
ChangePassword1.Visible = true;
Calendar2.Visible = false;
DetailsView1.Visible = false;
GridView1.Visible = false;
GridView2.Visible = false;
if (cg == "EZM")
{
lErrCPwd.Text = "Novo geslo ne sme biti zamenjajme ";
lErrCPwd.Visible = true;
}
if (cg == "EEP")
{
lErrCPwd.Text = "Novo geslo ne sme biti enako staremu !";
lErrCPwd.Visible = true;
}
}
}
else
{
Label1.Visible = false;
Label2.Visible = false;
Label3.Visible = false;
lChgPwd.Text = "Zamenjava gesla ni uspela!";
Label3.Visible = true;
}
}
else
{
lChgPwd.Visible = false;
if (cg == "CERR")
{
lErrCPwd.Text = "Povezava do podatkovne baze je prekinjena !";
lErrCPwd.Visible = true;
}
}
// Label1.Visible = true;
// Label2.Visible = true;
// Label3.Visible = true;
if (pwdCoda != null && pwdCoda != "VSP" && cg != "CERR")
{
SqlConnectionStringBuilder dsRjavUIP = new SqlConnectionStringBuilder();
dsRjavUIP.UserID = "irrs_app";
dsRjavUIP.Password = "******";
dsRjavUIP.DataSource = "10.10.50.161";
SqlConnection conUIP = new SqlConnection(dsRjavUIP.ConnectionString);
try
{
conUIP.Open();
}
catch (SqlException)
{
lVsp.Text = "Povezava do podatkovne baze je prekinjena.";
lVsp.Visible = true;
redString = "index.aspx?oper=" + oper + "&pwdCoda=" + pwdCoda + "&chgpwd=CERR";
Response.Redirect(redString);
}
sqlString = "select nd.PRI_IME from[UIP].[dbo].[UIP_EDC_LICODE] as lc inner join[UIP].[dbo].[UIP_NDUNAME] as un on un.UNAME=lc.UNAME inner join[UIP].[dbo].[UIP_NDELUPO] as nd on nd.SIFD=un.SIFD where lc.UNAME='" + Label2.Text + "' and lc.CODA='" + Label1.Text + "' and un.OZNAKA='EDC'";
SqlCommand commAmb = new SqlCommand(sqlString, conUIP);
// SqlCommand commAmb = new SqlCommand("select * from [UIP].[dbo].UIP_EDC_LICODE", conUIP);
using (SqlDataReader reader = commAmb.ExecuteReader())
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
Label5.Text = SIFRA;
Label3.Text = "Prijavljeni ste kot " + (reader.GetString(0));
Label5.Visible = false;
if (ChangePassword1.Visible == false)
{
Label6.Visible = true;
Label7.Visible = true;
Label8.Visible = true;
}
if (cg != "PWD")
{
DetailsView1.Visible = true;
GridView2.Visible = true;
Label7.Visible = true;
GridView1.Visible = true;
}
}
else
{
DetailsView1.Visible = false;
}
}
//Label3.Text = "Prijavljeni ste kot TEXT ";
}
// Novo
SqlConnectionStringBuilder dsM2 = new SqlConnectionStringBuilder();
dsM2.UserID = "irrs_app";
dsM2.Password = "******";
dsM2.DataSource = "moder2";
SqlConnection conM2Dat = new SqlConnection(dsM2.ConnectionString);
try
{
conM2Dat.Open();
}
catch (SqlException)
{
lVsp.Text = "Povezava do podatkovne baze je prekinjena.";
lVsp.Visible = true;
redString = "index.aspx?oper=" + oper + "&pwdCoda=" + pwdCoda + "&chgpwd=CERR";
Response.Redirect(redString);
}
sqlString = " select convert (char(10),max(AD.DAY),104) as datum from [TSSPICA].[DBO].ANALYTICS_DAILY as AD "
+ "inner join [TSSPICA].[DBO].USERS as U on U.NO =AD.USER_NO WHERE U.ID='" + Label2.Text + "' AND AD.DAY <= getdate() and AD.PLANNED_TIME>0";
SqlCommand commDat = new SqlCommand(sqlString, conM2Dat);
using (SqlDataReader reader = commDat.ExecuteReader())
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
Calendar2.TodaysDate = DateTime.Parse(reader.GetString(0));
Calendar2.SelectedDate = Calendar2.TodaysDate;
}
}
}
// end novo
Login1.Visible = false;
bChgPwd.Visible = true;
bOdjava.Visible = true;
}
else
{
Login1.Visible = true;
bChgPwd.Visible = false;
bOdjava.Visible = false;
Label4.Visible = false;
if (pwdCoda == "VSP")
{
lVsp.Text = "Prijava ni uspela. Poizkusite ponovno.";
lVsp.Visible = true;
}
}
}
