// public void SaveEmpDocumentInfo(EmployeeDocumentBo bo)
// {
// string query = @"INSERT INTO [SBP_Employee_Documents]
// ([Employee_ID]
// ,[Document_Type]
// ,[Document_Name]
// ,National_Id_imag
// ,CV_image)
// VALUES ('" + bo.Employee_Document_ID + @"' ,
// '" + bo.Employee_Document_Type + @"',
// '" + bo.Employee_Document_Name + @"',
// @NationalID,
// @CVPDF
// )";
// try
// {
// // _dbconnection.ConnectDatabase();
// _dbconnection.Connect_ImageDB();
// _dbconnection.AddParameter("@NationalID", SqlDbType.Binary, bo.National_Id_imag);
// _dbconnection.AddParameter("@CVPDF", SqlDbType.Binary, bo.CV_PDF);
// // _dbconnection.AddParameter("@image", bo.Employee_Document_Image);
// // _dbconnection.AddParameter("@imageNationalID", System .Convert .ToByte ,bo.Employee_NationalID_Image);
// this._dbconnection.ExecuteNonQuery(query);
// }
// catch (Exception ex)
// {
// throw ex;
// }
// }
#endregion
#region Update Document Info
public void UpdateDocumentInfo(EmployeeDocumentBo bo, int id)
{
string query = @"UPDATE [SBP_Employee_Documents]
SET
[Document_Type] ='" + bo.Employee_Document_Type + @"'
,[Document_Name] ='" + bo.Employee_Document_Name + @"'
,[Update_Date] =convert(varchar(11),getdate(),106)
,[Entry_By] = 0
WHERE [Employee_ID]='" + id + @"'
";
try
{
this._dbconnection.ConnectDatabase();
/// this._dbconnection.AddParameter("@image", SqlDbType.Image, bo.National_Id_imag);
this._dbconnection.ExecuteNonQuery(query);
_dbconnection.Connect_ImageDB();
//query = "DELETE FROM HR_Emp_DocFile WHERE [Emp_ID] ='" + bo.Employee_Document_ID + "' ";
// this._dbconnection.ExecuteNonQuery(query);
query = @"UPDATE [HR_Emp_DocFile] Set[Emp_NID_Photo]=@NationalID , [Emp_CV_PDF]=@CVPDF Where [Emp_ID] ='" + bo.Employee_Document_ID + "' ";
_dbconnection.AddParameter("@NationalID", SqlDbType.Binary, bo.National_Id_imag);
_dbconnection.AddParameter("@CVPDF", SqlDbType.Binary, bo.CV_PDF);
this._dbconnection.ExecuteNonQuery(query);
_dbconnection.ConnectDatabase();
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveEmpDocumentInfo(EmployeeDocumentBo bo)
{
string query = @"INSERT INTO [HR_Emp_DocFile]
(
[Emp_ID]
,[Emp_NID_Photo]
,Emp_CV_PDF
)
VALUES ('" + bo.Employee_Document_ID + @"'
, @NationalID
, @CVPDF
)";
try
{
_dbconnection.Connect_ImageDB();
_dbconnection.AddParameter("@NationalID", SqlDbType.Binary, bo.National_Id_imag);
_dbconnection.AddParameter("@CVPDF", SqlDbType.Binary, bo.CV_PDF);
this._dbconnection.ExecuteNonQuery(query);
query = @"INSERT INTO [SBP_Employee_Documents]
(
[Employee_ID]
,[Document_Type]
,[Document_Name]
)
VALUES ('" + bo.Employee_Document_ID + @"' ,
'" + bo.Employee_Document_Type + @"',
'" + bo.Employee_Document_Name + @"'
)";
_dbconnection.ConnectDatabase();
this._dbconnection.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
