private void Save()
{
//ed.WriteMessage("Save\n");
Atend.Base.Design.DUser user = new Atend.Base.Design.DUser();
user.UserName = txtUserName.Text;
user.Password = txtPassword.Text;
user.Name = txtName.Text;
user.Family = txtFamily.Text;
foreach (TreeNode tr in tvAccess.Nodes)
{
if (tr.Checked)
{
user.AccessList.Add(Convert.ToInt32(tr.Tag));
}
}
if (SelectUser == 0)
{
ed.WriteMessage("INSERT \n");
if (user.insertX())
{
Reset();
}
else
{
MessageBox.Show("امکان ثبت اطلاعات نمی باشد", "خطا");
}
}
else
{
ed.WriteMessage("UPDATE \n");
user.Code = SelectUser;
if (user.updateX())
{
Reset();
}
else
{
MessageBox.Show("امکان ثبت اطلاعات نمی باشد", "خطا");
}
}
}
//public static bool ShareUserAccessOnServer()
//{
// Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
// SqlConnection Serverconnection = new SqlConnection(Atend.Control.ConnectionString.ServercnString);
// SqlTransaction Servertransaction;
// try
// {
// Serverconnection.Open();
// Servertransaction = Serverconnection.BeginTransaction();
// try
// {
// DataTable LocalUserTbl = Atend.Base.Design.DUser.SelectAll();
// foreach (DataRow LocalUserRow in LocalUserTbl.Rows)
// {
// Atend.Base.Design.DUser User = Atend.Base.Design.DUser.ServerSelectByUsernameAndPassword(Servertransaction, Serverconnection, LocalUserRow["UserName"].ToString(), LocalUserRow["PassWord"].ToString());
// if (User.Code != -1)
// {
// if (!Atend.Base.Design.DUser.ServerDelete(Servertransaction, Serverconnection, User.Code))
// {
// Servertransaction.Rollback();
// Serverconnection.Close();
// return false;
// }
// }
// User.Name = LocalUserRow["Name"].ToString();
// User.Family = LocalUserRow["Family"].ToString();
// User.Password = LocalUserRow["Password"].ToString();
// User.UserName = LocalUserRow["UserName"].ToString();
// DataTable AccessForUser = DUserAccess.SelectByUserId(Convert.ToInt32(LocalUserRow["Code"].ToString()));
// foreach (DataRow dr in AccessForUser.Rows)
// {
// User.AccessList.Add(Convert.ToInt32(dr["IdAccess"]));
// }
// if (!User.insert(Servertransaction, Serverconnection))
// {
// Servertransaction.Rollback();
// Serverconnection.Close();
// return false;
// }
// }
// Servertransaction.Commit();
// Serverconnection.Close();
// return true;
// }
// catch (System.Exception exp)
// {
// ed.WriteMessage(string.Format("Error In TransAction of ShareUserAccessOnServer:{0}\n", exp.Message));
// Servertransaction.Rollback();
// Serverconnection.Close();
// return false;
// }
// }
// catch (System.Exception exp)
// {
// ed.WriteMessage(string.Format(" ERROR DACCESS.ShareUserAccessOnServer {0}\n", exp.Message));
// Serverconnection.Close();
// return false;
// }
// return true;
//}
public static bool GetUserAccessFromServer()
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
SqlConnection Localconnection = new SqlConnection(Atend.Control.ConnectionString.LocalcnString);
SqlTransaction Localtransaction;
try
{
Localconnection.Open();
Localtransaction = Localconnection.BeginTransaction();
try
{
DataTable ServerUserTbl = Atend.Base.Design.DUser.ServerSelectAll();
foreach (DataRow ServerUserRow in ServerUserTbl.Rows)
{
Atend.Base.Design.DUser User = Atend.Base.Design.DUser.SelectByUsernameAndPassword(Localtransaction, Localconnection, ServerUserRow["UserName"].ToString(), ServerUserRow["PassWord"].ToString());
if (User.Code != -1)
{
if (!Atend.Base.Design.DUser.Delete(Localtransaction, Localconnection, User.Code))
{
Localtransaction.Rollback();
Localconnection.Close();
return(false);
}
}
User.Name = ServerUserRow["Name"].ToString();
User.Family = ServerUserRow["Family"].ToString();
User.Password = ServerUserRow["Password"].ToString();
User.UserName = ServerUserRow["UserName"].ToString();
DataTable AccessForUser = DUserAccess.ServerSelectByUserId(Convert.ToInt32(ServerUserRow["Code"].ToString()));
foreach (DataRow dr in AccessForUser.Rows)
{
User.AccessList.Add(Convert.ToInt32(dr["IdAccess"]));
}
if (!User.insertX(Localtransaction, Localconnection))
{
Localtransaction.Rollback();
Localconnection.Close();
return(false);
}
}
Localtransaction.Commit();
Localconnection.Close();
return(true);
}
catch (System.Exception exp)
{
ed.WriteMessage(string.Format("Error In TransAction of GetUserAccessFromServer:{0}\n", exp.Message));
Localtransaction.Rollback();
Localconnection.Close();
return(false);
}
}
catch (System.Exception exp)
{
ed.WriteMessage(string.Format(" ERROR DACCESS.GetUserAccessFromServer {0}\n", exp.Message));
Localconnection.Close();
return(false);
}
return(true);
}