private void tbBarcode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
string code = tbBarcode.Text;
this.Details = DBLayer.Clients.GetDetails(code);
this.WithoutKey = false;
ArrayList al = DBLayer.Clients.GetOnlineList();
for (int i = 0; i < al.Count; i++)
{
string codeOnline = ((DBLayer.Clients.Clients_WideDetails)al[i]).Barcode;
//MessageBox.Show(codeOnline);
if (tbBarcode.Text == codeOnline)
{
//MessageBox.Show("Yes");
this.ForExit = true;
break;
}
}
SimulateSelectClient();
}
}
private void btnNext_Click(object sender, EventArgs e)
{
if (cbWithout.Checked)
{
int[] i;
int SelRow = -1;
i = advBandedGridView1.GetSelectedRows();
SelRow = i[0];
int ind = 0;
try
{
ind = Convert.ToInt32(advBandedGridView1.GetRowCellValue(SelRow, "Id"));
}
catch (Exception err)
{
MessageBox.Show(this, err.Message, Lib.StringConstants.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.WithoutKey = true;
this.Details = DBLayer.Clients.GetDetails(ind);
//MessageBox.Show(this.Details.FIO);
SimulateSelectClient();
}
else
{
string code = Lib.ServiceFunctions.ScanPrefix() + tbBarcode.Text;
try
{
this.Details = DBLayer.Clients.GetDetails(code);
this.WithoutKey = false;
ArrayList al = DBLayer.Clients.GetOnlineList();
for (int i = 0; i < al.Count; i++)
{
string codeOnline = ((DBLayer.Clients.Clients_WideDetails)al[i]).Barcode;
//MessageBox.Show(codeOnline);
if (Lib.ServiceFunctions.ScanPrefix() + tbBarcode.Text == codeOnline)
{
//MessageBox.Show("Yes");
this.ForExit = true;
break;
}
}
SimulateSelectClient();
}
catch (Exception err)
{
MessageBox.Show("На данную карту не заведен клиент!" + err.Message, Lib.StringConstants.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void LoadData()
{
ArrayList al = DBLayer.Clients.GetBirthDates(this.Month);
DataTable dt = new DataTable();
dt.Columns.Add("FIO");
dt.Columns.Add("Phone");
dt.Columns.Add("Birthdate", typeof(DateTime));
for (int i = 0; i < al.Count; i++)
{
DBLayer.Clients.Details det = (DBLayer.Clients.Details)al[i];
DataRow dr = dt.Rows.Add();
dr["FIO"] = det.FIO;
dr["Birthdate"] = det.BirthDate;
dr["Phone"] = det.Phone;
}
grSales.DataSource = dt;
advBandedGridView1.BestFitColumns();
slblCount.Text = al.Count.ToString();
}
private void btnNext_Click(object sender, EventArgs e)
{
if (cbWithout.Checked)
{
int[] i;
int SelRow = -1;
i = advBandedGridView1.GetSelectedRows();
SelRow = i[0];
int ind = 0;
try
{
ind = Convert.ToInt32(advBandedGridView1.GetRowCellValue(SelRow, "Id"));
}
catch (Exception err)
{
MessageBox.Show(this, err.Message, Lib.StringConstants.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.WithoutKey = true;
this.Details = DBLayer.Clients.GetDetails(ind);
LoadClient();
}
else
{
string code = Lib.ServiceFunctions.ScanPrefix() + tbBarcode.Text;
this.Details = DBLayer.Clients.GetDetails(code);
LoadClient();
}
}
public FrmEditClientAbonement(DBLayer.Clients.Details det)
{
InitializeComponent();
this.Details = det;
LoadCoaches(1);
}
public static int Insert(DBLayer.Clients.Details det)
{
string sql = "INSERT INTO Clients (DocumentId, TypeId, SourceId, FIO, Barcode, RegisterDate, BirthDate, DocumentNumber, Phone, Sex) ";
sql += " VALUES (" + det.DocumentId.ToString() + ", " + det.TypeId.ToString() + ", " + det.SourceId.ToString() + ", '" + det.FIO + "', '" + det.Barcode + "', '" + det.RegisterDate.ToString("yyyyMMdd") + "', '" + det.BirthDate.ToString("yyyyMMdd") + "', '" + det.DocumentNumber + "', '" + det.Phone + "', " + det.Sex.ToString() + ")";
ZFort.DB.Execute.ExecuteString_void(sql);
sql = "SELECT Max([Id]) AS MaxId FROM Clients";
return((int)ZFort.DB.Execute.ExecuteString_Scalar(sql));
}
public CtrlVisit(int id)
{
InitializeComponent();
tbBarcode.Focus();
this.Details = DBLayer.Clients.GetDetails(id);
tbBarcode.Text = this.Details.Barcode;
btnView.Enabled = false;
gridControl1.Enabled = false;
tbFIO.Enabled = false;
cbLeave.Enabled = false;
}
public CtrlBoxType(DBLayer.Clients.Details det)
{
InitializeComponent();
int id = det.Sex;
DBLayer.Abonements.Details aDet = DBLayer.Abonements.GetClientLast(det.Id);
lblAbonement.Text = aDet.Name;
lblFIO.Text = det.FIO;
DBLayer.ClientsAbonements.Details caDet = DBLayer.ClientsAbonements.GetDetails(det.Id, aDet.Id);
if (caDet.CoachId != 0)
{
lblCoach.Text = DBLayer.Coaches.GetDetails(caDet.CoachId).Name;
}
lblTime.Text = caDet.Time;
lblWeekdays.Text = caDet.Weekdays;
try
{
lblFinishDate.Text = DBLayer.ClientsAbonements.GetFinishDate(det.Id, aDet.Id).ToString("dd-MMM-yyyy");
}
catch
{
}
int doubleBox = DBLayer.Boxes.GetList(1, id);
int singleBox = DBLayer.Boxes.GetList(2, id);
if (id == 0)
{
int val = 0;
val = singleBox;
singleBox = doubleBox;
doubleBox = val;
}
lblSingle.Text = (singleBox - DBLayer.Boxes.GetReserved(1, id).Count).ToString();
lblDouble.Text = (doubleBox - DBLayer.Boxes.GetReserved(2, id).Count).ToString();
}
public FrmViewClient(DBLayer.Clients.Details det)
{
InitializeComponent();
byte[] result = DBLayer.Clients.DownloadPhoto(det.Id);
try
{
MemoryStream ms = new MemoryStream(result, 0, result.Length);
Image im = Image.FromStream(ms);
pbPhoto.Image = im;
}
catch (Exception ee)
{
pbPhoto.Image = null;
}
lblFIO.Text = det.FIO;
lblBirthDate.Text = det.BirthDate.ToString("dd-MMM-yyyy");
}
public static void Delete(int id)
{
string user = ((DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User")).FIO;
DBLayer.ClientsAbonements.Details det = DBLayer.ClientsAbonements.GetDetails(id);
DBLayer.Clients.Details cDet = DBLayer.Clients.GetDetails(det.ClientId);
DBLayer.Abonements.Details aDet = DBLayer.Abonements.GetDetails(det.AbonementId);
DBLayer.DeletingLog.DeletingLog_Details dlDet = new DeletingLog.DeletingLog_Details();
dlDet.Date = DateTime.Now;
dlDet.Name = aDet.Name + "/" + cDet.FIO + "(" + aDet.Cost.ToString() + ")";
dlDet.Type = 0;
dlDet.User = user;
DBLayer.DeletingLog.Insert(dlDet);
ZFort.DB.Execute.ExecuteString_void("DELETE FROM ClientsAbonements WHERE [Id] = " + id.ToString());
}
public FrmEditClient(int id)
{
InitializeComponent();
//btnOk.Enabled = false;
this.Id = id;
this.Details = DBLayer.Clients.GetDetails(id);
tbFIO.Text = this.Details.FIO;
tbCode.Text = this.Details.Barcode;
tbRegisterDate.Text = this.Details.RegisterDate.ToString("dd-MMM-yyyy");
tbDay.Text = this.Details.BirthDate.Date.Day.ToString();
cbMonth.SelectedIndex = this.Details.BirthDate.Date.Month - 1;
tbYear.Text = this.Details.BirthDate.Date.Year.ToString();
tbDocumentNumber.Text = this.Details.DocumentNumber;
tbPhone.Text = this.Details.Phone;
LoadGroups(this.Details.TypeId);
LoadSources(this.Details.SourceId);
LoadDocument(this.Details.DocumentId);
byte[] result = DBLayer.Clients.DownloadPhoto(Id);
try
{
MemoryStream ms = new MemoryStream(result, 0, result.Length);
Image im = Image.FromStream(ms);
pbPhoto.Image = im;
}
catch (Exception ee)
{
pbPhoto.Image = null;
}
LoadData();
cbSex.SelectedIndex = Details.Sex;
}
public static void Update(DBLayer.Clients.Details det)
{
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [DocumentId] = " + det.DocumentId.ToString() + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [SourceId] = " + det.SourceId.ToString() + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [TypeId] = " + det.TypeId.ToString() + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [FIO] = '" + det.FIO + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [Barcode] = '" + det.Barcode + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [DocumentNumber] = '" + det.DocumentNumber + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [Phone] = '" + det.Phone + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [RegisterDate] = '" + det.RegisterDate.ToString("yyyyMMdd") + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [BirthDate] = '" + det.BirthDate.ToString("yyyyMMdd") + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Clients SET [Sex] = " + det.Sex.ToString() + " WHERE [Id] = " + det.Id.ToString());
}
public CtrlExitInfo(DBLayer.Clients.Details det)
{
InitializeComponent();
this.Details = det;
lblClient.Text = det.FIO;
int id = DBLayer.Visits.GetLastVisit(det.Id);
DBLayer.Visits.Visits_Details vDet = DBLayer.Visits.GetDetails(id);
lblBox.Text = DBLayer.Boxes.GetNumber(vDet.BoxId).ToString();
this.VisitId = id;
if (id != 0)
{
DBLayer.Visits.Visits_Details detV = DBLayer.Visits.GetDetails(id);
lblDate.Text = detV.Time;
}
}
private void btnView_Click(object sender, EventArgs e)
{
int[] i;
int SelRow = -1;
i = advBandedGridView1.GetSelectedRows();
SelRow = i[0];
int ind = 0;
try
{
ind = Convert.ToInt32(advBandedGridView1.GetRowCellValue(SelRow, "Id"));
}
catch (Exception err)
{
MessageBox.Show(this, err.Message, Lib.StringConstants.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Details = DBLayer.Clients.GetDetails(ind);
ServiceForms.FrmViewClient frm = new FitnessProject.ServiceForms.FrmViewClient(DBLayer.Clients.GetDetails(ind));
frm.ShowDialog();
}
public CtrlInfo(DBLayer.Clients.Details det, DateTime date, int number, int type, bool key, int coachId)
{
InitializeComponent();
this.Details = det;
this.Date = date;
this.Type = type;
this.Number = number;
this.WithoutKey = key;
this.CoachId = coachId;
LoadCoaches();
string text = "";
switch (type)
{
case 1:
text = "Женский";
break;
case 2:
text = "Мужской";
break;
case 3:
text = "Женский";
break;
case 4:
text = "Мужской";
break;
}
lblClient.Text = det.FIO;
byte[] result = DBLayer.Clients.DownloadPhoto(det.Id);
try
{
MemoryStream ms = new MemoryStream(result, 0, result.Length);
Image im = Image.FromStream(ms);
pbPhoto.Image = im;
}
catch (Exception ee)
{
pbPhoto.Image = null;
}
DBLayer.Abonements.Details aDet = DBLayer.Abonements.GetClientLast(det.Id);
lblAbonement.Text = aDet.Name;
lblTime.Text = aDet.Time;
lblWeekdays.Text = aDet.Weekdays;
try
{
lblCoach.Text = DBLayer.Coaches.GetDetails(aDet.CoachId).Name;
}
catch
{
lblCoach.Text = "Не указан";
}
DBLayer.ClientsAbonements.Details caDet = DBLayer.ClientsAbonements.GetDetails(det.Id, aDet.Id);
CADetails = caDet;
if (caDet.VisitsCount > 0)
{
lblVisitCount.Text = caDet.VisitsCount.ToString();
}
lblDate.Text = date.ToString("dd-MMM-yyyy hh mm");
lblNumber.Text = number.ToString() + " " + text;
}
