private void FillAliasGrid()
{
try
{
AliasDataTable = new DataTable();
DataSet CredentialsDataSet = new DataSet();
AliasDataTable = VSWebBL.ConfiguratorBL.CredentialsBL.Ins.GetAllData();
//if (AliasDataTable.Rows.Count > 0)
//{
DataTable dtcopy = AliasDataTable.Copy();
dtcopy.PrimaryKey = new DataColumn[] { dtcopy.Columns["ID"] };
Session["Alias"] = dtcopy;
AliasGridView.DataSource = AliasDataTable;
AliasGridView.DataBind();
//}
//else
//{
// AliasGridView.DataSource = AliasDataTable;
// AliasGridView.DataBind();
//}
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
private void AutoDnsButton_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in AliasGridView.SelectedRows)
{
try
{
row.AccessibilityObject.GetChild(2).Value =
Dns.GetHostByAddress(IPAddress.Parse(
row.AccessibilityObject.GetChild(1).Value)).HostName;
AliasGridView.Update();
}
catch
{
row.AccessibilityObject.GetChild(1).Value = "!!!" +
row.AccessibilityObject.GetChild(1).Value;
}
}
}
protected void ButtonAdd_Attribute(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(NameColumn.Text))
{
throw new InvalidOperationException("Поле «Псевдоним» не может содержать пустую строку.");
}
if (string.IsNullOrWhiteSpace(NameAttribute.Text))
{
throw new InvalidOperationException("Поле «Код» не может содержать пустую строку.");
}
List <char> num = new List <char>()
{
'0', '1', '2', '3', '4', '5', '6', '7', '8', '9'
};
if (num.Contains(NameAttribute.Text[0]))
{
throw new InvalidOperationException("«Код» не может начинатсья с цифры.");
}
var query = string.Format(@"EXEC [model].[UserAttributeAdd] '{0}', '{1}', '{2}', '{3}'",
EntityList.SelectedValue, NameAttribute.Text.Trim(), ListType.SelectedValue, NameColumn.Text.Trim());
using (var conn = new SqlConnection(Global.ConnectionString))
using (var cmd = new SqlCommand(query, conn))
{
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
throw new InvalidOperationException(String.Format("Не удалось добавить атрибут в таблицу.\n{0}.", ex.Message));
}
}
NameColumn.Text = NameAttribute.Text = null;
AddAttriabute.Close();
AliasGridView.DataBind();
}
protected void okbtn_Click(object sender, EventArgs e)
{
Session["password"] = cnfrmpassword.Text;
//UpdatenewPasswordField(cnfrmpassword.Text);
ASPxPopupControl3.ShowOnPageLoad = false;
GridViewDataColumn Name = AliasGridView.Columns["Password"] as GridViewDataColumn;
LinkButton lnkbtn = AliasGridView.FindEditRowCellTemplateControl(Name, "LinkButton2") as LinkButton;
LinkButton linkedit = AliasGridView.FindEditRowCellTemplateControl(Name, "LinkButton1") as LinkButton;
//1/27/2016 Durga modified for VSPLUS-2500
Label msglabel = AliasGridView.FindEditRowCellTemplateControl(Name, "msg") as Label;
lnkbtn.Visible = true;
linkedit.Visible = false;
msglabel.Text = "<b>" +
"</b>Password updated successfully." +
"<button type=\"button\" class=\"close\" data-dismiss=\"alert\"><span aria-hidden=\"true\">×</span><span class=\"sr-only\">Close</span></button>";
msglabel.Style.Value = "display: block";
msglabel.Visible = true;
}
private void FillAliasGridfromSession()
{
try
{
AliasDataTable = new DataTable();
if (Session["Alias"] != "" && Session["Alias"] != null)
{
AliasDataTable = (DataTable)Session["Alias"];
}
if (AliasDataTable.Rows.Count > 0)
{
AliasGridView.DataSource = AliasDataTable;
AliasGridView.DataBind();
}
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
