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(); }