protected void BtnLogin_Click(object sender, EventArgs e)
{
if (TxtUserName.Text == string.Empty || TxtPassword.Text == string.Empty)
{
LblState.Text = "من فضلك ادخل اسم المستخدم و كلمة المرور";
LblState.ForeColor = Color.Red;
return;
}
dsMain ds = new dsMain();
dsMainTableAdapters.UserInfoTableAdapter adpUser = new dsMainTableAdapters.UserInfoTableAdapter();
if (adpUser.FillByUserPass(ds.UserInfo, TxtUserName.Text, TxtPassword.Text) <= 0)
{
LblState.Text = "خطاء في اسم المستخدم او كلمة السر";
LblState.ForeColor = Color.Red;
return;
}
dsMain.UserInfoRow user = ds.UserInfo[0];
sessionRetirementWeb.UserID = user.id.ToString();
sessionRetirementWeb.SyndicateId = user.SyndicateId.ToString();
sessionRetirementWeb.IsAdmin = user.isadmin;
sessionRetirementWeb.DatabaseName = user.dataname;
sessionRetirementWeb.UserName = user.name;
if (Request.QueryString["RedirectURL"] == null)
{
Response.Redirect("~/");
}
else
{
Response.Redirect(Request.QueryString["RedirectURL"]);
}
}
public void loadDBFToDb(FileInfo dbfFile, string TableName, SqlConnection connection)
{
NDbfReader.Table dbfTable = NDbfReader.Table.Open(dbfFile.Open(FileMode.Open));
NDbfReader.Reader dbfReader = dbfTable.OpenReader(System.Text.Encoding.GetEncoding(866));
SqlTransaction TRA = connection.BeginTransaction(("Bulk" + TableName));
SqlBulkCopy da = new SqlBulkCopy(connection, SqlBulkCopyOptions.Default, TRA);
da.BulkCopyTimeout = 60000;
da.DestinationTableName = "Fias_tmp." + TableName;
dsMain ds = new dsMain();
DataTable servertable = ds.Tables[TableName];
List <DataRow> rows = new List <DataRow>();
while (dbfReader.Read())
{
DataRow newrow = servertable.NewRow();
foreach (NDbfReader.Column c in dbfTable.Columns)
{
newrow.SetField(c.Name, dbfReader.GetValue(c.Name));
}
rows.Add(newrow);
}
da.WriteToServer(rows.ToArray());
TRA.Commit();
dbfTable.Dispose();
dbfFile.Delete();
}
