public static ArrayList GetList(int id)
{
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable("SELECT * FROM Administrators AS a INNER JOIN UserAdministrator AS ua ON a.[Id] = ua.[AdministratorId] WHERE ua.UserId = " + id.ToString());
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.Administrators.Details det = new DBLayer.Administrators.Details();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.FIO = dr["FIO"].ToString();
if (!dr.IsNull("IsTired"))
{
det.IsTired = Convert.ToBoolean(dr["IsTired"]);
}
al.Add(det);
}
return(al);
}
private void LoadData()
{
ArrayList al = DBLayer.Administrators.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name");
dt.Columns.Add("Tired");
for (int i = 0; i < al.Count; i++)
{
DBLayer.Administrators.Details det = (DBLayer.Administrators.Details)al[i];
DataRow dr = dt.Rows.Add();
dr["Id"] = det.Id;
dr["Name"] = det.FIO;
if (det.IsTired)
{
dr["Tired"] = "Уволен";
}
}
grSources.DataSource = dt;
}
public static ArrayList GetList()
{
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable("SELECT * FROM Administrators");
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.Administrators.Details det = new DBLayer.Administrators.Details();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.FIO = dr["FIO"].ToString();
if (!dr.IsNull("IsTired"))
{
det.IsTired = Convert.ToBoolean(dr["IsTired"]);
}
al.Add(det);
}
return(al);
}
public FrmEditAdministrator(int id)
{
InitializeComponent();
this.Id = id;
this.Details = DBLayer.Administrators.GetDetails(id);
tbName.Text = this.Details.FIO;
cbTired.Checked = this.Details.IsTired;
}
private void LoadList()
{
DBLayer.Users.Details detU = (DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User");
ArrayList al = DBLayer.Administrators.GetList();
for (int i = 0; i < al.Count; i++)
{
DBLayer.Administrators.Details det = (DBLayer.Administrators.Details)al[i];
Lib.ServiceFunctions.ListItem li = new FitnessProject.Lib.ServiceFunctions.ListItem();
li.ID = det.Id;
li.Name = det.FIO;
ddlAdministrators.Items.Add(li);
}
}
private void LoadData()
{
ArrayList al = DBLayer.Administrators.GetList();
for (int i = 0; i < al.Count; i++)
{
DBLayer.Administrators.Details det = (DBLayer.Administrators.Details)al[i];
if (!det.IsTired)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = det.FIO;
lvi.Tag = det.Id;
lvAdministrators.Items.Add(lvi);
}
}
}
public static void Update(DBLayer.Administrators.Details det)
{
ZFort.DB.Execute.ExecuteString_void("UPDATE Administrators SET [FIO] = '" + det.FIO + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Administrators SET [IsTired] = " + Convert.ToInt32(det.IsTired).ToString() + " WHERE [Id] = " + det.Id.ToString());
}
/*#region Check
*
* public static bool Check(string name, int id)
* {
*
* Database.Service serv = new Management.Database.Service();
*
* return serv.AdvertisingSource_Check(name, id);
* }
*
#endregion*/
#region Insert
public static void Insert(DBLayer.Administrators.Details det)
{
ZFort.DB.Execute.ExecuteString_void("INSERT INTO Administrators ([FIO], IsTired) VALUES ('" + det.FIO + "', " + Convert.ToInt32(det.IsTired).ToString() + ")");
}
