public void RegisterNewMember(MemberInfo_ViewModel info, Fee_Model fee, DateTime Day_Create) { //get Register New Member SaveMember_DAO.SaveNewMember(info.SKU, info.FullName, info.Nation, info.Address, info.PhoneNumber, info.Register_day, info.Day_of_Birth, info.Place_of_Birth, Day_Create, false, info.Image); saveFee_DAO.saveFee(fee); SaveMember_DAO.SaveLevel(info.listLevel, info.RegisterNumber); }
public void EditMember_Info(MemberInfo_ViewModel info, DateTime Day_Create) { {//get Register New Member SaveMember_DAO.EditMember(info.RegisterNumber, info.SKU, info.FullName, info.Nation, info.Address, info.PhoneNumber, info.Register_day, info.Day_of_Birth, info.Place_of_Birth, Day_Create, false, info.Image); SaveMember_DAO.EditRegisterClass(info.RegisterNumber, info.ID_Class, info.Register_day); SaveMember_DAO.EditLevel(info.listLevel, info.RegisterNumber); } }
private MemberInfo_ViewModel getDB_FromForm() { MemberInfo_ViewModel info = new MemberInfo_ViewModel(); if (!txtRegisterNumber.Text.Equals("")) { info.RegisterNumber = int.Parse(txtRegisterNumber.Text); //TH edit } else if (changevalueRegisterNumber == false && txtRegisterNumber.Text.Equals("")) { info.RegisterNumber = db.NewRegisterNumber() + 1; changevalueRegisterNumber = true; } //TH New else { info.RegisterNumber = db.NewRegisterNumber(); //TH đã có mã mới rồi -> h thì in } info.SKU = txtSKU.Text; info.FullName = txtName.Text; info.Nation = txtNation.Text; info.Address = txtAddress.Text; info.PhoneNumber = txtPhone.Text; info.Register_day = dtpRegisterDay.SelectedDate.Value; info.Day_of_Birth = (dtpBirthday.SelectedDate == null) ? DateTime.MinValue : dtpBirthday.SelectedDate.Value.Date; info.Place_of_Birth = txtBirthplace.Text; info.ID_Class = int.Parse(cboRegisterClass.SelectedValue.ToString()); info.Class_Name = cboRegisterClass.Text; info.Image = arrImage; info.listLevel = new Dictionary <string, DateTime>(); info.listLevel.Add("Cap6", (dtpLevel6.SelectedDate == null) ? DateTime.MinValue : dtpLevel6.SelectedDate.Value); info.listLevel.Add("Cap5", (dtpLevel5.SelectedDate == null) ? DateTime.MinValue : dtpLevel5.SelectedDate.Value); info.listLevel.Add("Cap4", (dtpLevel4.SelectedDate == null) ? DateTime.MinValue : dtpLevel4.SelectedDate.Value); info.listLevel.Add("Cap3", (dtpLevel3.SelectedDate == null) ? DateTime.MinValue : dtpLevel3.SelectedDate.Value); info.listLevel.Add("Cap2", (dtpLevel2.SelectedDate == null) ? DateTime.MinValue : dtpLevel2.SelectedDate.Value); info.listLevel.Add("Cap1", (dtpLevel1.SelectedDate == null) ? DateTime.MinValue : dtpLevel1.SelectedDate.Value); info.listLevel.Add("DANVN1", (dtpDanVN1.SelectedDate == null) ? DateTime.MinValue : dtpDanVN1.SelectedDate.Value); info.listLevel.Add("DANVN2", (dtpDanVN2.SelectedDate == null) ? DateTime.MinValue : dtpDanVN2.SelectedDate.Value); info.listLevel.Add("DANVN3", (dtpDanVN3.SelectedDate == null) ? DateTime.MinValue : dtpDanVN3.SelectedDate.Value); info.listLevel.Add("DANVN4", (dtpDanVN4.SelectedDate == null) ? DateTime.MinValue : dtpDanVN4.SelectedDate.Value); info.listLevel.Add("DANVN5", (dtpDanVN5.SelectedDate == null) ? DateTime.MinValue : dtpDanVN5.SelectedDate.Value); info.listLevel.Add("DANVN6", (dtpDanVN6.SelectedDate == null) ? DateTime.MinValue : dtpDanVN6.SelectedDate.Value); info.listLevel.Add("DANVN7", (dtpDanVN7.SelectedDate == null) ? DateTime.MinValue : dtpDanVN7.SelectedDate.Value); info.listLevel.Add("DANVN8", (dtpDanVN8.SelectedDate == null) ? DateTime.MinValue : dtpDanVN8.SelectedDate.Value); info.listLevel.Add("DANAIKIKAI1", (dtpDanAIKIKAI1.SelectedDate == null) ? DateTime.MinValue : dtpDanAIKIKAI1.SelectedDate.Value); info.listLevel.Add("DANAIKIKAI2", (dtpDanAIKIKAI2.SelectedDate == null) ? DateTime.MinValue : dtpDanAIKIKAI2.SelectedDate.Value); info.listLevel.Add("DANAIKIKAI3", (dtpDanAIKIKAI3.SelectedDate == null) ? DateTime.MinValue : dtpDanAIKIKAI3.SelectedDate.Value); info.listLevel.Add("DANAIKIKAI4", (dtpDanAIKIKAI4.SelectedDate == null) ? DateTime.MinValue : dtpDanAIKIKAI4.SelectedDate.Value); info.listLevel.Add("DANAIKIKAI5", (dtpDanAIKIKAI5.SelectedDate == null) ? DateTime.MinValue : dtpDanAIKIKAI5.SelectedDate.Value); info.listLevel.Add("DANAIKIKAI6", (dtpDanAIKIKAI6.SelectedDate == null) ? DateTime.MinValue : dtpDanAIKIKAI6.SelectedDate.Value); info.listLevel.Add("DANAIKIKAI7", (dtpDanAIKIKAI7.SelectedDate == null) ? DateTime.MinValue : dtpDanAIKIKAI7.SelectedDate.Value); info.listLevel.Add("DANAIKIKAI8", (dtpDanAIKIKAI8.SelectedDate == null) ? DateTime.MinValue : dtpDanAIKIKAI8.SelectedDate.Value); return(info); }
private void DoPrint() { ExportWord exportWord = new ExportWord(); MemberInfo_ViewModel info = getDB_FromForm(); SettingImage_BLO settingImage_BLO = new SettingImage_BLO(); try { exportWord.CreateDocument(info, settingImage_BLO.getBackGround(), ref i); } catch { MessageBox.Show("Đóng các file word không sử dụng trước khi in file mới"); return; } if (changevalueRegisterNumber == true) { SetEmplty(); changevalueRegisterNumber = false; } }
private void save_Method() { DateTime Day_Create = DateTime.Now; MemberInfo_ViewModel info = new MemberInfo_ViewModel(); Fee_Model fee = new Fee_Model(); info = getDB_FromForm(); fee.RegisterNumber = info.RegisterNumber; fee.Day_Create = DateTime.Now; fee.Delete_Flag = false; fee.Fee_Type = "Hội Phí"; fee.Fee_Value = 0; fee.ID_Class = info.ID_Class; fee.Month = DateTime.Now.Month; fee.Year = DateTime.Now.Year; if (txtRegisterNumber.Text.Equals("")) { try { db.RegisterNewMember(info, fee, Day_Create); } catch (Exception r) { MessageBox.Show("Lưu không thành công" + r, "Lỗi"); return; } } else { try { db.EditMember_Info(info, Day_Create); } catch (Exception r) { MessageBox.Show("Lưu không thành công" + r, "Lỗi"); return; } } MessageBox.Show("Lưu Thành Công"); }
public void CreateDocument(MemberInfo_ViewModel info, Image image, ref int i) { //Create New Word Document doc = new Document(); if (image != null) { Image resize = (Image)(new Bitmap(image, new System.Drawing.Size(900, 1000))); //PictureWatermark picture = new PictureWatermark(); //picture.Picture = image; ////picture.IsWashout = false; //doc.Watermark = picture; doc.Background.Type = BackgroundType.Picture; doc.Background.Picture = resize; } //Add Section Spire.Doc.Section section = doc.AddSection(); section.PageSetup.PageSize = PageSize.A4; //section.PageSetup.Margins.Top = 150; //section.PageSetup.PageBorderIncludeHeader = false; //section.PageSetup.Margins.Bottom = 0; //section.PageSetup.Margins.Left = 89.85f; //section.PageSetup.Margins.Right = 89.85f; section.PageSetup.Borders.Bottom.Space = 0; //Add Paragraph Paragraph pHeader = section.AddParagraph(); //Header TextRange textRangel = pHeader.AppendText("HỒ SƠ HỌC VIÊN"); textRangel.CharacterFormat.Bold = true; textRangel.CharacterFormat.TextColor = System.Drawing.Color.Blue; textRangel.CharacterFormat.FontSize = 24; textRangel.CharacterFormat.FontName = "Calibri Light (Headings)"; pHeader.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Center; pHeader.Format.AfterSpacing = 5; //SKU draw(doc, 210, 22, 20, 5, "SKU: " + info.SKU); //Register Number draw(doc, 210, 22, 260, -9, "SỐ ĐĂNG KÝ: " + info.RegisterNumber); //Name draw(doc, 450, 22, 20, 8, "HỌ TÊN: " + info.FullName); //Quốc Tịch draw(doc, 450, 22, 20, 25, "QUỐC TỊCH: " + info.Nation); //Address draw(doc, 450, 22, 20, 42, "ĐỊA CHỈ: " + info.Address); //PHONE draw(doc, 450, 22, 20, 60, "SỐ ĐIỆN THOẠI: " + info.PhoneNumber); //Image imageDraw(doc, 145, 115, 15, 75, info.Image); //Register Day draw(doc, 320, 22, 150, 67, "NGÀY ĐĂNG KÝ: " + info.Register_day.ToShortDateString()); // Day of Birth draw(doc, 320, 22, 150, 90, "NGÀY SINH : " + info.Day_of_Birth.ToShortDateString()); //Place of Birth draw(doc, 320, 22, 150, 115, "NƠI SINH: " + info.Place_of_Birth); //Class draw(doc, 320, 22, 150, 139, "LỚP: " + info.Class_Name); //Cap 1-6 draw(doc, 450, 22, 20, 160, "CẤP 6: " + (info.listLevel["Cap6"] != DateTime.MinValue ? info.listLevel["Cap6"].ToShortDateString() : "")); draw(doc, 450, 22, 20, 177, "CẤP 5: " + (info.listLevel["Cap5"] != DateTime.MinValue ? info.listLevel["Cap5"].ToShortDateString() : "")); draw(doc, 450, 22, 20, 193, "CẤP 4: " + (info.listLevel["Cap4"] != DateTime.MinValue ? info.listLevel["Cap4"].ToShortDateString() : "")); draw(doc, 450, 22, 20, 209, "CẤP 3: " + (info.listLevel["Cap3"] != DateTime.MinValue ? info.listLevel["Cap3"].ToShortDateString() : "")); draw(doc, 450, 22, 20, 225, "CẤP 2: " + (info.listLevel["Cap2"] != DateTime.MinValue ? info.listLevel["Cap2"].ToShortDateString() : "")); draw(doc, 450, 22, 20, 240, "CẤP 1: " + (info.listLevel["Cap1"] != DateTime.MinValue ? info.listLevel["Cap1"].ToShortDateString() : "")); draw(doc, 210, 22, 20, 260, "I DAN VN: " + (info.listLevel["DANVN1"] != DateTime.MinValue ? info.listLevel["DANVN1"].ToShortDateString() : "")); draw(doc, 210, 22, 20, 278, "II DAN VN: " + (info.listLevel["DANVN2"] != DateTime.MinValue ? info.listLevel["DANVN2"].ToShortDateString() : "")); draw(doc, 210, 22, 20, 296, "III DAN VN: " + (info.listLevel["DANVN3"] != DateTime.MinValue ? info.listLevel["DANVN3"].ToShortDateString() : "")); draw(doc, 210, 22, 20, 314, "IV DAN VN: " + (info.listLevel["DANVN4"] != DateTime.MinValue ? info.listLevel["DANVN4"].ToShortDateString() : "")); draw(doc, 210, 22, 20, 332, "V DAN VN: " + (info.listLevel["DANVN5"] != DateTime.MinValue ? info.listLevel["DANVN5"].ToShortDateString() : "")); draw(doc, 210, 22, 20, 350, "VI DAN VN: " + (info.listLevel["DANVN6"] != DateTime.MinValue ? info.listLevel["DANVN6"].ToShortDateString() : "")); draw(doc, 210, 22, 20, 368, "VII DAN VN: " + (info.listLevel["DANVN7"] != DateTime.MinValue ? info.listLevel["DANVN7"].ToShortDateString() : "")); draw(doc, 210, 22, 20, 384, "VIII DAN VN: " + (info.listLevel["DANVN8"] != DateTime.MinValue ? info.listLevel["DANVN8"].ToShortDateString() : "")); draw(doc, 210, 22, 260, 150, "I DAN AIKIDAI: " + (info.listLevel["DANAIKIKAI1"] != DateTime.MinValue ? info.listLevel["DANAIKIKAI1"].ToShortDateString() : "")); draw(doc, 210, 22, 260, 168, "II DAN AIKIDAI: " + (info.listLevel["DANAIKIKAI2"] != DateTime.MinValue ? info.listLevel["DANAIKIKAI2"].ToShortDateString() : "")); draw(doc, 210, 22, 260, 185, "III DAN AIKIDAI: " + (info.listLevel["DANAIKIKAI3"] != DateTime.MinValue ? info.listLevel["DANAIKIKAI3"].ToShortDateString() : "")); draw(doc, 210, 22, 260, 204, "IV DAN AIKIDAI: " + (info.listLevel["DANAIKIKAI4"] != DateTime.MinValue ? info.listLevel["DANAIKIKAI4"].ToShortDateString() : "")); draw(doc, 210, 22, 260, 220, "V DAN AIKIDAI: " + (info.listLevel["DANAIKIKAI5"] != DateTime.MinValue ? info.listLevel["DANAIKIKAI5"].ToShortDateString() : "")); draw(doc, 210, 22, 260, 238, "VI DAN AIKIDAI: " + (info.listLevel["DANAIKIKAI6"] != DateTime.MinValue ? info.listLevel["DANAIKIKAI6"].ToShortDateString() : "")); draw(doc, 210, 22, 260, 256, "VII DAN AIKIDAI: " + (info.listLevel["DANAIKIKAI7"] != DateTime.MinValue ? info.listLevel["DANAIKIKAI7"].ToShortDateString() : "")); draw(doc, 210, 22, 260, 274, "VIII DAN AIKIDAI: " + (info.listLevel["DANAIKIKAI8"] != DateTime.MinValue ? info.listLevel["DANAIKIKAI8"].ToShortDateString() : "")); //Save and launch i++; doc.SaveToFile("MemberInfo" + i + ".docx", FileFormat.Docx); Process myProcess = new Process(); try { myProcess = Process.Start("MemberInfo" + i + ".docx"); } catch { } }