bool AggiungiLogin(string login, string password)
{
//DataTable T1 = Conn.SQLRunner(
// "select DISTINCT loginname = (case when (o.sid = 0x00) then NULL else l.loginname end) " +
// " from dbo.sysusers o " +
// "left join master.dbo.syslogins l on l.sid = o.sid " +
// "where ((o.issqlrole != 1 and o.isapprole != 1 ) or (o.sid = 0x00) " +
// "and o.hasdbaccess = 1)and o.isaliased != 1 ");
DataTable T1 = Conn.SQLRunner(
"select DISTINCT loginname from master.dbo.syslogins " +
"where hasaccess = 1 and isntgroup=0");
//esce se la login è già presente
if (T1 != null)
{
foreach (DataRow R1 in T1.Rows)
{
if (R1["loginname"].ToString().ToUpper() == login.ToUpper())
{
return(true);
}
}
}
string err;
string dbname = Conn.GetSys("database").ToString();
Conn.DO_SYS_CMD(//"EXEC sp_addlogin " + QHS.quote(login)+","+QHS.quote(password)
"CREATE LOGIN [" + login + "] WITH PASSWORD="******"," +
"DEFAULT_DATABASE = " + dbname + "," +
"CHECK_EXPIRATION = OFF," +
"CHECK_POLICY = OFF"
, out err);
if (err != null)
{
MessageBox.Show("Errore creando la login " + login + ": " + err);
return(false);
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
string FileName;
string cmd = Session["AttachmentCommand"] as string;
string fname = Session["AttachmentFileName"] as string;
if (cmd == null)
{
return;
}
string MyGuid = Session.SessionID.ToString();
string str;
str = DateTime.Now.ToString();
str = str.Replace("/", "");
str = str.Replace(".", "");
str = str.Replace(" ", "");
//Costruisce il nome del File (AnnoMeseGiornoOraMinutiSecondi)
//FileName = str.Substring(4,4) + str.Substring(2,2) + str.Substring(0,2) + "h" + str.Substring(8,str.Length - 8);
string prefix = Session["TipoUtente"] as String;
if (prefix == "fornitore")
{
prefix += "-" + Session["CodiceFornitore"].ToString();
}
if (prefix == "responsabile")
{
prefix += "-" + Session["CodiceResponsabile"].ToString();
}
prefix = GetVars.GetUsrVar(this, "CodiceDipartimento").ToString() + "-" + prefix + "-";
prefix = prefix.Replace("\\", "");
prefix = prefix.Replace("/", "");
prefix = prefix.Replace("*", "");
prefix = prefix.Replace("?", "");
prefix = prefix.Replace("$", "");
prefix = prefix.Replace("%", "");
FileName = prefix + "-" + System.Guid.NewGuid().ToString() + fname;
string errmess;
Easy_DataAccess Conn = GetVars.GetUserConn(this);
object doc = Conn.DO_SYS_CMD(cmd, true);
if (doc == null || doc == DBNull.Value)
{
Session["Messaggio"] = "Documento non trovato";
Session["CloseWindow"] = true;
Session["AttachmentCommand"] = null;
Session["AttachmentFileName"] = null;
Response.Redirect("Messaggio.aspx");
return;
}
// Restituisce il percorso fisico locale della cartella ReportPDF ex: c:\inetpub\wwwroot\.....
string FilePath = this.MapPath("ReportPDF");
if (!FilePath.EndsWith("\\"))
{
FilePath += "\\";
}
string filenametodelete = FilePath + prefix + "*.*";
string[] existingreports = System.IO.Directory.GetFiles(
FilePath, prefix + "*.*");
foreach (string filename in existingreports)
{
System.IO.File.Delete(filename);
}
string PDFfilePathRedir = //FilePath +
"ReportPDF/" +
FileName;
string sw = Path.Combine(FilePath, FileName);
FileStream FS = new FileStream(sw, FileMode.Create, FileAccess.Write);
byte[] ByteArray = (byte[])doc;
int n = ByteArray.Length;
if (n == 0)
{
Session["Messaggio"] = "Documento non trovato";
Session["CloseWindow"] = true;
Session["AttachmentCommand"] = null;
Session["AttachmentFileName"] = null;
Response.Redirect("Messaggio.aspx");
return;
}
try {
FS.Write(ByteArray, 0, n);//<<<<<<<<<
FS.Flush();
FS.Close();
}
catch {
string mym = "Non è stato possibile completare il salvataggio del file. \r";
Session["CloseWindow"] = true;
Session["Messaggio"] = mym;
Response.Redirect("Messaggio.aspx");
return;
}
//Visualizza il Report in formato PDF
//WebLog.Log(this,"Visualizza il file in formato PDF");
Session["AttachmentCommand"] = null;
Session["AttachmentFileName"] = null;
Response.Redirect(PDFfilePathRedir);
}