public List <loginclasse> ViewUser(String cmnd)
{
List <loginclasse> data = new List <loginclasse>();
SqlCommand req = new SqlCommand();
openconx();
req.Connection = cnn;
req.CommandType = CommandType.Text; // Changer le type de la requete en text (non pas procedure)
req.CommandText = cmnd;
req.Parameters.Clear();
datareader = req.ExecuteReader();
while (datareader.Read())
{
loginclasse item = new loginclasse();
item.User = datareader.GetValue(1).ToString();
item.Pasword = datareader.GetValue(2).ToString();
item.Type = datareader.GetValue(3).ToString();
data.Add(item);
// data.Add(new article_model((int)datareader.GetValue(0), (String)datareader.GetValue(1),(String) datareader.GetValue(2),(String) datareader.GetValue(3), (String)datareader.GetValue(4), (String)datareader.GetValue(5),(float) datareader.GetValue(6), (int)datareader.GetValue(7), (DateTime)datareader.GetValue(8),(byte[]) datareader.GetValue(9)));
}
return(data);
}
//-------------------Getting the xml data from creating file ---
public loginclasse getXmldata()
{
DataSet ds = new DataSet();
loginclasse user = new loginclasse();
try
{
if (Exists(filePath))
{
ds.Clear();
ds.ReadXml(filePath);
int table = Convert.ToInt32(ds.Tables.Count);
for (int i = 0; i < table; i++)
{
user.User = ds.Tables[i].Rows[0][0].ToString();
user.Pasword = ds.Tables[i].Rows[0][1].ToString();
user.Type = ds.Tables[i].Rows[0][2].ToString();
}
return(user);
}
else
{
return(null);
}
}
catch
{
}
return(user);
}
private void backlogin_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
progresbar.Hide();
DataTable dt = (DataTable)e.Result;
if (dt.Rows.Count > 0)
{
loginclasse user = new loginclasse();
user.User = dt.Rows[0][1].ToString();
user.Pasword = dt.Rows[0][2].ToString();
user.Type = dt.Rows[0][3].ToString();
Properties.Settings.Default.User = user.User;
Properties.Settings.Default.Password = user.Pasword;
Properties.Settings.Default.type = user.Type;
Properties.Settings.Default.Save();
if (remamber.Checked)
{
fileio.writeXml(user);
}
userSuccessfullyAuthenticated.UserSuccessfullyAuthenticated();
}
else
{
MessageBox.Show("votre nom d'utilisateur ou mot de passe sont incorrects\n");
}
}
private void upload_Click(object sender, EventArgs e)
{
loginclasse User = new loginclasse();
User.User = Username.Text;
User.Pasword = new Hash().Hashing(Password.Text);
User.Type = type.SelectedText;
progesabar.Show();
if (!add.IsBusy)
{
add.RunWorkerAsync(User);
}
}
private void add_DoWork(object sender, DoWorkEventArgs e)
{
loginclasse user = (loginclasse)e.Argument;
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@user", SqlDbType.VarChar, 40);
param[0].Value = user.User;
param[1] = new SqlParameter("@pass", SqlDbType.VarChar, 250);
param[1].Value = user.Pasword;
param[2] = new SqlParameter("@type", SqlDbType.VarChar, 40);
param[2].Value = user.Type;
SqlConnection.ExuteCommende("Add_User", param);
}
//------------------- insert the data into created xml file-------------
public void writeXml(loginclasse user)
{
XmlWriterSettings settings = new XmlWriterSettings();
settings.Indent = true;
settings.OmitXmlDeclaration = true;
settings.NewLineOnAttributes = true;
XmlWriter writer = XmlWriter.Create(filePath, settings);
writer.WriteStartDocument();
writer.WriteComment("This file is generated by the program.");
writer.WriteStartElement("Users");
writer.WriteStartElement("user");
writer.WriteElementString("username", user.User);
writer.WriteElementString("password", user.Pasword);
writer.WriteElementString("type", user.Type);
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Flush();
writer.Close();
}