private void button3_Click(object sender, EventArgs e)
{
try
{
DateTime dateTime = DateTime.ParseExact(textBox4.Text + " " + comboBox2.Text + " " + textBox3.Text, "d MMMM yyyy",
new System.Globalization.CultureInfo("th-TH"));
dateTime = dateTime.AddHours(DateTime.Now.Hour);
dateTime = dateTime.AddMinutes(DateTime.Now.Minute);
dateTime = dateTime.AddSeconds(DateTime.Now.Second);
var memCourse = new ApplyCourseLog();
memCourse.ApplyDate = dateTime;
memCourse.MemberId = this.Member.MemberId;
memCourse.CourseName = "รายเดือน";
memCourse.Name = this.Member.Name;
memCourse.LastName = this.Member.LastName;
memCourse.CoursePrice = Convert.ToInt32(textBox7.Text.Trim());
DateTime expireDate = DateTime.ParseExact(textBox6.Text + " " + comboBox3.Text + " " + textBox5.Text, "d MMMM yyyy",
new System.Globalization.CultureInfo("th-TH"));
this.Member.ExpireDate = expireDate;
StorageManager.GetSingleton().SaveObjectChanged(this.Member);
StorageManager.GetSingleton().MemberMontlyApplyCourse(this.Member, memCourse, dateTime);
m_currentMemberCourse = StorageManager.GetSingleton().GetApplyCourseLogByMemberID(this.Member.MemberId);
}
catch
{
}
}
public void MemberMontlyApplyCourse(Member member, ApplyCourseLog memCourse, DateTime accessDate)
{
GetDB().ApplyCourseLog.Add(memCourse);
AccessLog accessLog = new AccessLog();
accessLog.AccessDate = accessDate;
accessLog.MemberID = member.MemberId;
accessLog.AccessType = COURSETYPE.MONTLY;
accessLog.Name = member.Name;
accessLog.LastName = member.LastName;
GetDB().AccessLog.Add(accessLog);
SaveDB();
}
private void gvPayments_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == gvPayments.Columns["printButton"].Index)
{
Payment.GetPayment().PrintRecipt((PaymentInfo)gvPayments.CurrentRow.DataBoundItem, true);
}
if (e.ColumnIndex == gvPayments.Columns["delButton"].Index)
{
ApplyCourseLog applylog = StorageManager.GetSingleton().GetPaymentByID((int)gvPayments.CurrentRow.Cells[0].Value);
var mForm = new DialogForm("ยืนยันการลบ?", $"ลบ {applylog.CourseName} ราคา {applylog.CoursePrice}");
if (mForm.ShowDialog() == DialogResult.OK)
{
StorageManager.GetSingleton().RemovePayment(applylog);
InitData();
MessageBox.Show("ลบข้อมูลเรียบร้อยแล้ว");
}
}
}
public void MemberApplyCourse(Member member, Course course)
{
ApplyCourseLog acl = new ApplyCourseLog();
acl.CourseName = course.CourseName;
acl.MemberId = member.MemberId;
acl.Name = member.Name;
acl.ApplyDate = DateTime.Now;
acl.LastName = member.LastName;
acl.CoursePrice = course.CoursePrice;
GetDB().ApplyCourseLog.Add(acl);
if (member.ExpireDate == null)
{
member.ExpireDate = DateTime.Now.AddDays(course.TotalDay);
}
else
{
member.ExpireDate = member.ExpireDate.Value.AddDays(course.TotalDay);
}
GetDB().Entry(member).State = System.Data.Entity.EntityState.Modified;
MemberApplyCourse mac = GetMemberApplyCourseByMemberID(member.MemberId);
if (mac == null)
{
mac = new MemberApplyCourse();
mac.CourseID = course.CourseID;
mac.ApplyDate = DateTime.Now;
mac.MemberId = member.MemberId;
GetDB().MemberApplyCourses.Add(mac);
}
else
{
mac.CourseID = course.CourseID;
mac.ApplyDate = DateTime.Now;
mac.MemberId = member.MemberId;
GetDB().Entry(mac).State = System.Data.Entity.EntityState.Modified;
}
SaveDB();
}
public void MemberDailyApplyCourse(Member member, ApplyCourseLog memCourse)
{
// var access = GetDB().AccessLog.Where(f => (f.AccessDate.Day == DateTime.Now.Day
//&& f.AccessDate.Month == DateTime.Now.Month
//&& f.AccessDate.Year == DateTime.Now.Year) &&
//f.MemberID == member.MemberId).SingleOrDefault();
// if (access == null)
// {
GetDB().ApplyCourseLog.Add(memCourse);
AccessLog accessLog = new AccessLog();
accessLog.MemberID = member.MemberId;
accessLog.AccessDate = DateTime.Now;
accessLog.AccessType = COURSETYPE.DAILY;
accessLog.Name = member.Name;
accessLog.LastName = member.LastName;
GetDB().AccessLog.Add(accessLog);
SaveDB();
//}
}
private void btnSave_Click(object sender, EventArgs e)
{
var member = new Member();
member.Name = txtName.Text.Trim();
member.LastName = "";
member.BirthDate = DateTime.Now;
member.Age = 0;
member.Gender = enumGender.Male;
member.CreateDate = DateTime.Now;
member.IsActive = true;
member.FingerPrint = "Daily";
var memCourse = new ApplyCourseLog();
memCourse.ApplyDate = DateTime.Now;
memCourse.CourseName = "รายวัน";
memCourse.MemberId = member.MemberId;
memCourse.Name = txtName.Text.Trim();
memCourse.LastName = txtUnit.Text.Trim() + " คน";
memCourse.CoursePrice = Convert.ToInt32(txtPrice.Text.Trim()) * Convert.ToInt32(txtUnit.Text.Trim());
StorageManager.GetSingleton().MemberDailyApplyCourse(member, memCourse);
PaymentInfo payment = new PaymentInfo();
ApplyCourseLog applyCourseLog = StorageManager.GetSingleton().GetLastPayment();
payment.ID = applyCourseLog.AutoID;
payment.PayDate = applyCourseLog.ApplyDate.ToString("dd/MM/yyyy");
payment.PayTime = applyCourseLog.ApplyDate.ToString("hh:mm:ss");
payment.PayName = $"{applyCourseLog.Name} {applyCourseLog.LastName}";
payment.Price = applyCourseLog.CoursePrice;
payment.CourseName = applyCourseLog.CourseName;
Payment.GetPayment().PrintRecipt(payment, true);
Form1.m_instance.FocusToMainForm();
this.Close();
}
private void InitMember()
{
problemPanel.Visible = true;
// Detail
txtName.Text = this.Member.Name;
txtLastName.Text = this.Member.LastName;
txtThaiId.Text = this.Member.ThaiId;
textBox1.Text = this.Member.BirthDate.Day.ToString();
comboBox1.Text = this.Member.BirthDate.Date.ToString("MMMM", new System.Globalization.CultureInfo("th-TH"));
textBox2.Text = this.Member.BirthDate.Date.ToString("yyyy", new System.Globalization.CultureInfo("th-TH"));
if (this.Member.ExpireDate != null)
{
textBox6.Text = this.Member.ExpireDate?.Day.ToString();
comboBox3.Text = this.Member.ExpireDate?.Date.ToString("MMMM", new System.Globalization.CultureInfo("th-TH"));
textBox5.Text = this.Member.ExpireDate?.Date.ToString("yyyy", new System.Globalization.CultureInfo("th-TH"));
}
m_currentMemberCourse = StorageManager.GetSingleton().GetApplyCourseLogByMemberID(this.Member.MemberId);
if (m_currentMemberCourse != null)
{
button1.Visible = true;
textBox4.Text = m_currentMemberCourse.ApplyDate.Day.ToString();
comboBox2.Text = m_currentMemberCourse.ApplyDate.Date.ToString("MMMM", new System.Globalization.CultureInfo("th-TH"));
textBox3.Text = m_currentMemberCourse.ApplyDate.Date.ToString("yyyy", new System.Globalization.CultureInfo("th-TH"));
textBox7.Text = m_currentMemberCourse.CoursePrice.ToString();
}
else
{
textBox7.Text = "0";
button1.Visible = false;
textBox4.Text = DateTime.Now.Day.ToString();
comboBox2.Text = DateTime.Now.Date.ToString("MMMM", new System.Globalization.CultureInfo("th-TH"));
textBox3.Text = DateTime.Now.Date.ToString("yyyy", new System.Globalization.CultureInfo("th-TH"));
textBox6.Text = DateTime.Now.Day.ToString();
comboBox3.Text = DateTime.Now.Date.ToString("MMMM", new System.Globalization.CultureInfo("th-TH"));
textBox5.Text = DateTime.Now.Date.ToString("yyyy", new System.Globalization.CultureInfo("th-TH"));
}
txtAge.Text = this.Member.Age.ToString();
lblFingerPrint.Text = this.Member.FingerPrint;
chkMale.Checked = (this.Member.Gender == enumGender.Male);
chkFemale.Checked = (this.Member.Gender == enumGender.Female);
txtHouseNumber.Text = this.Member.HouseNumber;
txtVillageNumber.Text = this.Member.VillageNumber;
txtVillageName.Text = this.Member.VillageName;
txtLane.Text = this.Member.Lane;
txtRoad.Text = this.Member.Road;
txtSubDistrict.Text = this.Member.SubDistrict;
txtDistrict.Text = this.Member.District;
txtProvince.Text = this.Member.Province;
txtPostCode.Text = this.Member.PostCode;
txtPhoneNumber.Text = this.Member.PhoneNumber;
txtEmail.Text = this.Member.Email;
if (this.Member.MemberProfile != null)
{
Image img = (Bitmap)((new ImageConverter()).ConvertFrom(this.Member.MemberProfile.ImageByte));
memberProfileImage.Image = img;
}
}
public void RemovePayment(ApplyCourseLog payment)
{
GetDB().ApplyCourseLog.Remove(payment);
SaveDB();
}
