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 { }
}
