// 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; } }