private void PrintButton_Click(object sender, EventArgs e)
{
MessageBox.Show("Đây là sản phẩm demo, chức năng này có trên sản phẩm chính thức", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
try
{
blankCertConfigModel = managingBlankCertConfigService.GetSingleByBlankCertType(blankCertTypeId);
BlankCertTypeComboBox.Enabled = false;
//Create a PrintDocument object
PrintDocument pd = new PrintDocument();
//Set PrinterName as the selected printer in the printers list
pd.PrinterSettings.PrinterName = PrinterComboBox.SelectedItem.ToString();
//Add PrintPage event handler
pd.PrintPage += Pd_PrintPage;
pd.EndPrint += Pd_EndPrint;
foreach (var certId in _certIds)
{
pd.DocumentName = certId.ToString();
pd.Print();
}
}
catch (Exception ex)
{
MessageBox.Show("In không thành công", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int AddBlankCertConfig(BlankCertConfigModel blankCertConfigModel)
{
try
{
return(blankCertConfigRepository.Add(blankCertConfigModel));
}
catch (Exception ex)
{
throw ex;
}
}
private void Pd_PrintPage(object sender, PrintPageEventArgs e)
{
int certId = int.Parse(((PrintDocument)sender).DocumentName);
CertModel certModel = managingCertService.GetSingleCertById(certId);
StudentModel studentModel = managingStudentService.GetSingleStudentById(certModel.StudentId);
BlankCertConfigModel blankCertConfigModel = managingBlankCertConfigService.GetSingleByBlankCertType(blankCertTypeId);
//Get the Graphics object
Graphics g = e.Graphics;
//Create a font Arial with size 16
Font font = new Font("Arial", 16);
//Create a solid brush with black color
SolidBrush brush = new SolidBrush(Color.Black);
if (blankCertTypeId == (int)Common.BlankCertType.HightSchool)
{
//g.DrawString("Hanhsama " + certId,
// font, brush,
// new Rectangle(20, 70, 200, 100));
//g.DrawString(studentModel.GraduatingYear.ToString(),
// font, brush,
// new Rectangle(blankCertConfigModel., 200, 100));
// thieu graduating year trong blankcertconfig
}
else if (blankCertTypeId == (int)Common.BlankCertType.JuniorHighSchool)
{
}
else if (blankCertTypeId == (int)Common.BlankCertType.University)
{
}
else if (blankCertTypeId == (int)Common.BlankCertType.Master)
{
}
}
public int Add(BlankCertConfigModel blankCertConfigModel)
{
using (conn = JBCertConnection.Instance)
{
string addCertQueryString = @"INSERT INTO [dbo].[tblThongsophoi]
([TruongX],[TruongY],[HovatenX],[HovatenY]
,[GioitinhX],[GioitinhY],[NgaysinhX],[NgaysinhY]
,[NganhdaotaoX],[NganhdaotaoY],[XeploaiX],[XeploaiY]
,[HinhthucdaotaoX],[HinhthucdaotaoY],[NgaytaovanbangX],[NgaytaovanbangY]
,[NoisinhX],[NoisinhY],[SohieuX],[SohieuY],[SovaosoX],[SovaosoY]
,[KhoathiX],[KhoathiY],[DantocX],[DantocY]
,[DiemthiX],[DiemthiY],[LoaiId],[IsActive],[UpdatedAt],[Ghichu],[IsDeleted])
Output INSERTED.Id
VALUES
(@TruongX,@TruongY,@HovatenX,@HovatenY,@GioitinhX,@GioitinhY,@NgaysinhX
,@NgaysinhY,@NganhdaotaoX,@NganhdaotaoY,@XeploaiX,@XeploaiY,@HinhthucdaotaoX,@HinhthucdaotaoY
,@NgaytaovanbangX,@NgaytaovanbangY,@NoisinhX,@NoisinhY,@SohieuX,@SohieuY,@SovaosoX
,@SovaosoY,@KhoathiX,@KhoathiY,@DantocX,@DantocY,@DiemthiX,@DiemthiY
,@LoaiId,@IsActive,@UpdatedAt,@Ghichu,0)" ;
string updateQueryString = @"Update [dbo].[tblThongsophoi]
Set [IsActive] = 0
Where [LoaiId] = @LoaiId and [Id] <> @Id";
conn.Open();
SqlCommand sqlCommand = null;
SqlTransaction sqlTransaction = conn.BeginTransaction();
try
{
sqlCommand = new SqlCommand(addCertQueryString, conn, sqlTransaction);
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Parameters.AddWithValue("@TruongX", blankCertConfigModel.SchoolX);
sqlCommand.Parameters.AddWithValue("@TruongY", blankCertConfigModel.SchoolY);
sqlCommand.Parameters.AddWithValue("@HovatenX", blankCertConfigModel.FullNameX);
sqlCommand.Parameters.AddWithValue("@HovatenY", blankCertConfigModel.FullNameY);
sqlCommand.Parameters.AddWithValue("@GioitinhX", blankCertConfigModel.GenderX);
sqlCommand.Parameters.AddWithValue("@GioitinhY", blankCertConfigModel.GenderY);
sqlCommand.Parameters.AddWithValue("@NgaysinhX", blankCertConfigModel.DobX);
sqlCommand.Parameters.AddWithValue("@NgaysinhY", blankCertConfigModel.DobY);
sqlCommand.Parameters.AddWithValue("@NganhdaotaoX", blankCertConfigModel.MajorX);
sqlCommand.Parameters.AddWithValue("@NganhdaotaoY", blankCertConfigModel.MajorY);
sqlCommand.Parameters.AddWithValue("@XeploaiX", blankCertConfigModel.RankingX);
sqlCommand.Parameters.AddWithValue("@XeploaiY", blankCertConfigModel.RankingY);
sqlCommand.Parameters.AddWithValue("@HinhthucdaotaoX", blankCertConfigModel.LearningModeX);
sqlCommand.Parameters.AddWithValue("@HinhthucdaotaoY", blankCertConfigModel.LearningModeY);
sqlCommand.Parameters.AddWithValue("@NgaytaovanbangX", blankCertConfigModel.CreatedDateX);
sqlCommand.Parameters.AddWithValue("@NgaytaovanbangY", blankCertConfigModel.CreatedDateY);
sqlCommand.Parameters.AddWithValue("@NoisinhX", blankCertConfigModel.BornedAddressX);
sqlCommand.Parameters.AddWithValue("@NoisinhY", blankCertConfigModel.BornedAddressY);
sqlCommand.Parameters.AddWithValue("@SohieuX", blankCertConfigModel.SerialX);
sqlCommand.Parameters.AddWithValue("@SohieuY", blankCertConfigModel.SerialY);
sqlCommand.Parameters.AddWithValue("@SovaosoX", blankCertConfigModel.ReferenceNumberX);
sqlCommand.Parameters.AddWithValue("@SovaosoY", blankCertConfigModel.ReferenceNumberY);
sqlCommand.Parameters.AddWithValue("@KhoathiX", blankCertConfigModel.ExamX);
sqlCommand.Parameters.AddWithValue("@KhoathiY", blankCertConfigModel.ExamY);
sqlCommand.Parameters.AddWithValue("@DantocX", blankCertConfigModel.EthnicX);
sqlCommand.Parameters.AddWithValue("@DantocY", blankCertConfigModel.EthnicX);
sqlCommand.Parameters.AddWithValue("@DiemthiX", blankCertConfigModel.ScoreX);
sqlCommand.Parameters.AddWithValue("@DiemthiY", blankCertConfigModel.ScoreY);
sqlCommand.Parameters.AddWithValue("@LoaiId", blankCertConfigModel.BlankCertTypeId);
sqlCommand.Parameters.AddWithValue("@IsActive", blankCertConfigModel.IsActive);
sqlCommand.Parameters.AddWithValue("@CreatedAt", blankCertConfigModel.CreatedAt);
sqlCommand.Parameters.AddWithValue("@Ghichu", blankCertConfigModel.Note);
int insertedId = (int)sqlCommand.ExecuteScalar();
if (blankCertConfigModel.IsActive == true)
{
sqlCommand = new SqlCommand(updateQueryString, conn, sqlTransaction);
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Parameters.AddWithValue("@LoaiId", blankCertConfigModel.BlankCertTypeId);
sqlCommand.Parameters.AddWithValue("@Id", insertedId);
sqlCommand.ExecuteNonQuery();
}
sqlTransaction.Commit();
}
catch (Exception ex)
{
sqlTransaction.Rollback();
throw ex;
}
finally
{
conn.Close();
}
}
return(1);
}
public BlankCertConfigModel GetSingleByBlankCertType(int blankCertTypeId)
{
BlankCertConfigModel blankCertConfigModel = new BlankCertConfigModel();
using (conn = JBCertConnection.Instance)
{
string queryString = @"SELECT a.*, b.Name as 'Tenloai'
FROM [dbo].[tblThongsophoi] as a
left join [dbo].[tblLoai] as b
on a.LoaiId = b.Id
where a.IsDeleted = 0 and a.IsActive = 1 and a.LoaiId = @LoaiId";
conn.Open();
SqlCommand sqlCommand = new SqlCommand(queryString, conn);
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Parameters.AddWithValue("@LoaiId", blankCertTypeId);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
try
{
if (sqlDataReader.Read())
{
blankCertConfigModel.Id = int.Parse(sqlDataReader["Id"].ToString());
blankCertConfigModel.SchoolX = int.Parse(sqlDataReader["TruongX"].ToString());
blankCertConfigModel.SchoolY = int.Parse(sqlDataReader["TruongY"].ToString());
blankCertConfigModel.FullNameX = int.Parse(sqlDataReader["HovatenX"].ToString());
blankCertConfigModel.FullNameY = int.Parse(sqlDataReader["HovatenY"].ToString());
blankCertConfigModel.GenderX = int.Parse(sqlDataReader["GioitinhX"].ToString());
blankCertConfigModel.GenderY = int.Parse(sqlDataReader["GioitinhY"].ToString());
blankCertConfigModel.DobX = int.Parse(sqlDataReader["NgaysinhX"].ToString());
blankCertConfigModel.DobY = int.Parse(sqlDataReader["NgaysinhY"].ToString());
blankCertConfigModel.MajorX = int.Parse(sqlDataReader["NganhdaotaoX"].ToString());
blankCertConfigModel.MajorY = int.Parse(sqlDataReader["NgaydaotaoY"].ToString());
blankCertConfigModel.RankingX = int.Parse(sqlDataReader["XeploaiX"].ToString());
blankCertConfigModel.RankingY = int.Parse(sqlDataReader["XeploaiY"].ToString());
blankCertConfigModel.LearningModeX = int.Parse(sqlDataReader["HinhthucdaotaoX"].ToString());
blankCertConfigModel.LearningModeY = int.Parse(sqlDataReader["HinhthucdaotaoY"].ToString());
blankCertConfigModel.CreatedDateX = int.Parse(sqlDataReader["NgaytaovanbangX"].ToString());
blankCertConfigModel.CreatedDateY = int.Parse(sqlDataReader["NgaytaovanbangY"].ToString());
blankCertConfigModel.BornedAddressX = int.Parse(sqlDataReader["NoisinhX"].ToString());
blankCertConfigModel.BornedAddressY = int.Parse(sqlDataReader["NoisinhY"].ToString());
blankCertConfigModel.SerialX = int.Parse(sqlDataReader["SohieuX"].ToString());
blankCertConfigModel.SerialY = int.Parse(sqlDataReader["SohieuY"].ToString());
blankCertConfigModel.ReferenceNumberX = int.Parse(sqlDataReader["SovaosoX"].ToString());
blankCertConfigModel.ReferenceNumberY = int.Parse(sqlDataReader["SovaosoY"].ToString());
blankCertConfigModel.ExamX = int.Parse(sqlDataReader["KhoathiX"].ToString());
blankCertConfigModel.ExamY = int.Parse(sqlDataReader["KhoathiY"].ToString());
blankCertConfigModel.EthnicX = int.Parse(sqlDataReader["DantocX"].ToString());
blankCertConfigModel.EthnicY = int.Parse(sqlDataReader["DantocY"].ToString());
blankCertConfigModel.ScoreX = int.Parse(sqlDataReader["DiemthiX"].ToString());
blankCertConfigModel.ScoreY = int.Parse(sqlDataReader["DiemthiY"].ToString());
blankCertConfigModel.BlankCertTypeId = int.Parse(sqlDataReader["LoaiId"].ToString());
blankCertConfigModel.BlankCertTypeName = sqlDataReader["Tenloai"].ToString();
blankCertConfigModel.IsActive = bool.Parse(sqlDataReader["IsActive"].ToString());
blankCertConfigModel.CreatedAt = DateTime.Parse(sqlDataReader["CreatedAt"].ToString());
blankCertConfigModel.Note = sqlDataReader["Ghichu"].ToString();
blankCertConfigModel.IsDeleted = bool.Parse(sqlDataReader["IsDeleted"].ToString());
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlDataReader.Close();
conn.Close();
}
}
return(blankCertConfigModel);
}
