public DataTableUpdater(ConnectionInfo Connection, DataTable Table, string table_name)
{
this.dt_now = DateTime.Now;
this.p_now = new NpgsqlParameter("p_now", this.dt_now);
this.connection = Connection;
this.table = Table;
this.table_name = table_name;
this.NotifyChangeSink = true;
this.UpdateUserInfo = true;
this.UserId = connection.UserId;
}
public static ConnectionInfo Create(string login, string password)
{
NpgsqlConnection connection = new NpgsqlConnection();
connection.ConnectionString =
System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
ConnectionInfo result = new ConnectionInfo();
result.Connection = connection;
result.UserName = login;
result.passwdhash = GetSHA1String(password, login);
result.Open();
object id = result.ExecuteScalar(
"select id from sys_user where username=:username and passwd=:passwd",
new NpgsqlParameter("username", login),
new NpgsqlParameter("passwd", result.passwdhash));
if(id == null || id is DBNull)
{
result.Dispose();
throw new SoapException("Neplatné jméno nebo heslo", SoapException.ClientFaultCode);
}
result.UserId = Convert.ToInt64(id);
return result;
}