private void tbtnSale_Click(object sender, EventArgs e)
{
for (int i = 0; i < advBandedGridView1.RowCount; i++)
{
double total = Convert.ToDouble(advBandedGridView1.GetRowCellValue(i, "Total"));
if (total > 0)
{
int quantity = Convert.ToInt32(advBandedGridView1.GetRowCellValue(i, "Quantity"));
int id = Convert.ToInt32(advBandedGridView1.GetRowCellValue(i, "Id"));
DBLayer.Users.Details det = ((DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User"));
DBLayer.Sales.Details sDet = new FitnessProject.DBLayer.Sales.Details();
sDet.Date = this.Date1;
sDet.ProductId = id;
sDet.UserId = det.Id;
sDet.Quantity = quantity;
DBLayer.Sales.Insert(sDet);
}
}
MessageBox.Show("Изменения сохранены");
}
public void Authorize()
{
//Database.Service1 serv = new FitnessProject.Database.Service1();
//serv.Initialize();
DBLayer.Users.Details det = DBLayer.Users.Authorize(tbLogin.Text, tbPassword.Text);
if (det.Id != 0)
{
AppDomain.CurrentDomain.SetData("User", det);
DBLayer.UserVisits.UserVisits_Details detV = new FitnessProject.DBLayer.UserVisits.UserVisits_Details();
detV.Date = DateTime.Now.Date;
detV.TimeOn = DateTime.Now.ToString("hh:mm");
detV.UserId = det.Id;
DBLayer.UserVisits.Insert(detV);
this.Close();
}
else
{
MessageBox.Show(this, "Неправильный логин или пароль!", Lib.StringConstants.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public FrmEditUser(int id)
{
InitializeComponent();
this.Id = id;
this.Details = DBLayer.Users.GetDetails(id);
tbCode.Text = this.Details.Barcode;
tbFIO.Text = this.Details.FIO;
tbJobTitle.Text = this.Details.JobTitle;
cbIsAdmin.Checked = this.Details.IsAdmin;
tbLogin.Text = this.Details.Login;
tbPassword.Text = this.Details.Password;
try
{
urDet = DBLayer.UserRate.GetDetails(this.Id);
}
catch { }
tbBar.Text = urDet.PercentForSales.ToString();
tbServices.Text = urDet.PercentForService.ToString();
tbAbonements.Text = urDet.PercentForClients.ToString();
tbConstant.Text = urDet.Constant.ToString();
tbFitness.Text = urDet.PercentForFitness.ToString();
tbMassage.Text = urDet.PercentForMassage.ToString();
LoadData();
LoadAdminsData();
}
/*#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.Users.Details det)
{
string sql = "INSERT INTO Users (FIO, JobTitle, Login, Password, Barcode, IsAdmin) ";
sql += " VALUES ('" + det.FIO + "', '" + det.JobTitle + "', '" + det.Login + "', '" + det.Password + "', '" + det.Barcode + "', " + Convert.ToInt32(det.IsAdmin).ToString() + ")";
ZFort.DB.Execute.ExecuteString_void(sql);
}
public static void Update(DBLayer.Users.Details det)
{
ZFort.DB.Execute.ExecuteString_void("UPDATE Users SET [FIO] = '" + det.FIO + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Users SET [JobTitle] = '" + det.JobTitle + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Users SET [Login] = '" + det.Login + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Users SET [IsAdmin] = " + Convert.ToInt32(det.IsAdmin).ToString() + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Users SET [Password] = '" + det.Password + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Users SET [Barcode] = '" + det.Barcode + "' WHERE [Id] = " + det.Id.ToString());
}
public CtrlClientType()
{
InitializeComponent();
LoadData();
DBLayer.Users.Details det = (DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User");
if (det.IsAdmin)
{
tbtnRemove.Visible = true;
}
else
{
tbtnRemove.Visible = false;
}
}
private void btnOk_Click(object sender, EventArgs e)
{
DBLayer.ServiceSales.Details det = new FitnessProject.DBLayer.ServiceSales.Details();
det.Date = DateTime.Now.Date;
det.ServiceId = this.Product.Id;
det.Quantity = Convert.ToInt32(tbQuantity.Text);
det.Time = DateTime.Now.ToShortTimeString();
DBLayer.Users.Details detU = (DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User");
det.UserId = detU.Id;
DBLayer.ServiceSales.Insert(det);
this.Close();
}
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);
}
}
public CtrlClient()
{
InitializeComponent();
LoadData();
DBLayer.Users.Details det = (DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User");
if (det.IsAdmin)
{
tbtnRemove.Visible = true;
}
else
{
tbtnRemove.Visible = false;
}
advBandedGridView1.ColumnFilterChanged += new EventHandler(advBandedGridView1_ColumnFilterChanged);
}
public CtrlCharges()
{
InitializeComponent();
SetData(DateTime.Now.Month, DateTime.Now.Year);
LoadData();
DBLayer.Users.Details det = (DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User");
if (det.IsAdmin)
{
tbtnRemove.Visible = true;
}
else
{
tbtnRemove.Visible = false;
}
}
private void LoadData()
{
ArrayList al = DBLayer.Users.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Code");
dt.Columns.Add("JobTitle");
dt.Columns.Add("FIO");
dt.Columns.Add("Login");
dt.Columns.Add("Administrator");
for (int i = 0; i < al.Count; i++)
{
DBLayer.Users.Details det = (DBLayer.Users.Details)al[i];
DataRow dr = dt.Rows.Add();
dr["Id"] = det.Id;
dr["Code"] = det.Barcode;
dr["JobTitle"] = det.JobTitle;
dr["FIO"] = det.FIO;
dr["Login"] = det.Login;
if (det.IsAdmin)
{
dr["Administrator"] = "Администратор";
}
else
{
dr["Administrator"] = "Пользователь";
}
}
grGoods.DataSource = dt;
}
public static ArrayList GetList()
{
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable("SELECT * FROM Users");
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.Users.Details det = new DBLayer.Users.Details();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.FIO = dr["FIO"].ToString();
det.Barcode = dr["Barcode"].ToString();
det.JobTitle = dr["JobTitle"].ToString();
det.Login = dr["Login"].ToString();
det.Password = dr["Password"].ToString();
if (!dr.IsNull("IsAdmin"))
{
det.IsAdmin = Convert.ToBoolean(dr["IsAdmin"]);
}
al.Add(det);
}
return(al);
}
private void btnOk_Click(object sender, EventArgs e)
{
if (this.AbonementId == 0)
{
MessageBox.Show(this, "Не указан абонемент!", Lib.StringConstants.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int a = 0;
if (this.Id == 0)
{
if (this.Details.Id == 0)
{
SimulateSelectAbonement();
}
else
{
this.CADetails.AbonementId = this.AbonementId;
DBLayer.Abonements.Details aDet = DBLayer.Abonements.GetDetails(this.CADetails.AbonementId);
this.CADetails.DateStart = Convert.ToDateTime(tbStartDate.Text);
this.CADetails.DateFinish = Convert.ToDateTime(tbFinishDate.Text);
this.CADetails.ClientId = this.Details.Id;
if (cbCoach.SelectedItem != null)
{
this.CADetails.CoachId = ((Lib.ServiceFunctions.ListItem)cbCoach.SelectedItem).ID;
}
this.CADetails.Time = tbTime.Text;
this.CADetails.Weekdays = tbWeekdays.Text;
if (aDet.LessonsCount != 0)
{
this.CADetails.VisitsCount = aDet.LessonsCount;
}
if (aDet.AdditionalVisits != 0)
{
this.CADetails.AdditionalCount = aDet.AdditionalVisits;
}
if (aDet.LessonsCount != 0)
{
this.CADetails.VisitsCount = aDet.LessonsCount;
}
if (aDet.AdditionalVisits != 0)
{
this.CADetails.AdditionalCount = aDet.AdditionalVisits;
}
if (MessageBox.Show(this, "Провести платеж - " + aDet.Cost.ToString() + "?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int caId = DBLayer.ClientsAbonements.Insert(this.CADetails);
DBLayer.AbonementIncome.Details det = new FitnessProject.DBLayer.AbonementIncome.Details();
DBLayer.Users.Details uDet = (DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User");
det.AbonementId = this.CADetails.AbonementId;
det.ClientId = this.CADetails.ClientId;
det.Date = DateTime.Now.Date;
det.Summ = aDet.Cost;
det.UserId = uDet.Id;
det.ClientAbonementId = caId;
DBLayer.AbonementIncome.Insert(det);
}
this.Close();
}
}
else
{
this.CADetails.AbonementId = this.AbonementId;
this.CADetails.DateStart = Convert.ToDateTime(tbStartDate.Text);
this.CADetails.DateFinish = Convert.ToDateTime(tbFinishDate.Text);
if (cbCoach.SelectedItem != null)
{
this.CADetails.CoachId = ((Lib.ServiceFunctions.ListItem)cbCoach.SelectedItem).ID;
}
this.CADetails.Time = tbTime.Text;
this.CADetails.Weekdays = tbWeekdays.Text;
DBLayer.ClientsAbonements.Update(this.CADetails);
this.Close();
}
}