/// <summary>
/// //////////////////////
public void UpdateEmployeeInformation(EmployeeBasicInfoBO objBasicBo, EmployeeAdditionalInfoBO objadditionalbo, int id)
{
if (objBasicBo.Employee_Discharge_Date == Convert.ToDateTime("1930-01-01"))
{
objBasicBo.Employee_Discharge_Date = Convert.ToDateTime(null);
}
string query = @"UPDATE [SBP_Employee_Master]
SET [Employee_ID] = " + objBasicBo.Employee_Id + ""
+ ",[Title] = '" + objBasicBo.Employee_Tittle + "'"
+ ",[First_Name] ='" + objBasicBo.Employee_First_Name + "'"
+ ",[Last_Name] ='" + objBasicBo.Employee_Last_Name + "'"
+ ",[Date_Of_Joining] ='" + objBasicBo.Employee_Join_Date + "'"
+ ",[Supervisor_EmpID] ='" + objBasicBo.Employee_Supervisor_Id + "'"
+ ",[Department] = '" + objBasicBo.Employee_Departmnent_Name + "'"
+ ",[Date_of_Birth] ='" + objBasicBo.Employee_Birth_Date + "'"
+ ",[Bank_Account_No] ='" + objadditionalbo.Employee_Bank_Acc_No + "'"
+ ",[Bank_ID] =" + objadditionalbo.Employee_Bank_Id + ""
+ ",[Bank_Name] ='" + objadditionalbo.Employee_Bank_Name + "'"
+ ",[Branch_ID] =" + objadditionalbo.Employee_Branch_Id + ""
+ ",[Bank_Branch] ='" + objadditionalbo.Employee_Branch_Name + "'"
+ ",[Bank_Routing_No] ='" + objadditionalbo.Employee_Bank_Route_No + "'"
+ ",[Nationality] ='" + objadditionalbo.Employee_Nationality + "'"
+ ",[National_ID_No] ='" + objadditionalbo.Employee_National_Id_No + "'"
+ ",[TIN] ='" + objadditionalbo.Employee_Tin + "'"
+ ",[Passport_No] ='" + objadditionalbo.Employee_Passport + "'"
+ ",[Contact_Number] ='" + objBasicBo.Employee_Contact_Number + "'"
+ ",[Alterate_Contact_Number] ='" + objBasicBo.Employee_Alter_Contact_Number + "'"
+ ",[Home_Phone] ='" + objBasicBo.Employee_Home_Phone + "'"
+ ",[Email] ='" + objBasicBo.Employee_Email + "'"
+ ",[Father_Name] ='" + objBasicBo.Employee_Father_Name + "'"
+ ",[Mother_Name] ='" + objBasicBo.Employee_Mother_Name + "'"
+ ",[Present_Address] ='" + objadditionalbo.Employee_Present_Address + "'"
+ ",[Permanent_Address] ='" + objadditionalbo.Employee_Permanent_Address + "'"
+ ",[Gender] ='" + objBasicBo.Employee_Gender + "'"
+ ",[Marital_Status] ='" + objBasicBo.Employee_Maritial_Status + "'"
+ ",[Date_Of_Discharge] ='" + objBasicBo.Employee_Discharge_Date + "'"
+ ",[Employee_Photo]=@image"
+ ",[Update_Date] =Convert(varchar(11),getdate(),106)"
+ ",[Entry_By] =0 WHERE Employee_ID=" + id;
try
{
this._dbconnection.ConnectDatabase();
this._dbconnection.AddParameter("@image", SqlDbType.Image, objadditionalbo.ImgByte);
this._dbconnection.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
public void SavetoDataBase(EmployeeBasicInfoBO bo, EmployeeAdditionalInfoBO ado)
{
DataTable dt = new DataTable();
string query = @"UPDATE SBP_Employee_Master
set Employee_Photo=@image where Employee_ID='" + bo.Employee_Id + "'";
try
{
this._dbconnection.ConnectDatabase();
this._dbconnection.AddParameter("@image", SqlDbType.Image, ado.ImgByte);
this._dbconnection.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
public bool CheckIsExistPhot(EmployeeBasicInfoBO bo)
{
bool result = false;
DataTable dt = new DataTable();
string checkQuery = @"select Employee_ID,Employee_Photo
from SBP_Employee_Master where Employee_ID= '" + bo.Employee_Id + "'";
try
{
this._dbconnection.ConnectDatabase();
dt = this._dbconnection.ExecuteQuery(checkQuery);
}
catch (Exception ex)
{
throw ex;
}
if (dt.Rows.Count > 0)
{
result = true;
}
return(result);
}
public void SaveEmployeeAllInformation(EmployeeBasicInfoBO objBasicBo, EmployeeAdditionalInfoBO objadditionalbo)
{
string queryString = "";
queryString = @"INSERT INTO [SBP_Employee_Master]
([Employee_ID]
,[Title]
,[First_Name]
,[Last_Name]
,[Date_Of_Joining]
,[Supervisor_EmpID]
,[Department]
,[Date_of_Birth]
,[Bank_Account_No]
,[Bank_ID]
,[Bank_Name]
,[Branch_ID]
,[Bank_Branch]
,[Bank_Routing_No]
,[Nationality]
,[National_ID_No]
,[TIN]
,[Passport_No]
,[Contact_Number]
,[Alterate_Contact_Number]
,[Home_Phone]
,[Email]
,[Father_Name]
,[Mother_Name]
,[Present_Address]
,[Permanent_Address]
,[Gender]
,[Marital_Status]
,[Date_Of_Discharge]
,[Emp_Stutse]
,[Employee_Photo]
,[Update_Date]
,[Entry_By]
)
VALUES ('" + objBasicBo.Employee_Id + "','"
+ objBasicBo.Employee_Tittle + "','"
+ objBasicBo.Employee_First_Name + "','"
+ objBasicBo.Employee_Last_Name + "','"
+ objBasicBo.Employee_Join_Date + "','"
+ objBasicBo.Employee_Supervisor_Id + "','"
+ objBasicBo.Employee_Departmnent_Name + "','"
+ objBasicBo.Employee_Birth_Date + "','"
+ objadditionalbo.Employee_Bank_Acc_No + "','"
+ objadditionalbo.Employee_Bank_Id + "','"
+ objadditionalbo.Employee_Bank_Name + "','"
+ objadditionalbo.Employee_Branch_Id + "','"
+ objadditionalbo.Employee_Branch_Name + "','"
+ objadditionalbo.Employee_Bank_Route_No + "','"
+ objadditionalbo.Employee_Nationality + "','"
+ objadditionalbo.Employee_National_Id_No + "','"
+ objadditionalbo.Employee_Tin + "','"
+ objadditionalbo.Employee_Passport + "','"
+ objBasicBo.Employee_Contact_Number + "','"
+ objBasicBo.Employee_Alter_Contact_Number + "','"
+ objBasicBo.Employee_Home_Phone + "','"
+ objBasicBo.Employee_Email + "','"
+ objBasicBo.Employee_Father_Name + "','"
+ objBasicBo.Employee_Mother_Name + "','"
+ objadditionalbo.Employee_Present_Address + "','"
+ objadditionalbo.Employee_Permanent_Address + "','"
+ objBasicBo.Employee_Gender + "','"
+ objBasicBo.Employee_Maritial_Status + "','"
+ objBasicBo.Employee_Discharge_Date + "','"
+ objBasicBo.Employee_Status + "','"
+ objadditionalbo.ImgByte + "',Getdate(),'0')"
;
try
{
this._dbconnection.ConnectDatabase();
//this._dbconnection.AddParameter("@image", SqlDbType.Image, objadditionalbo.ImgByte);
this._dbconnection.ExecuteNonQuery(queryString);
this._dbconnection.CloseDatabase();
queryString = @"INSERT INTO HR_EmpImageDT
(
Emp_ID,
Emp_Image
)
VALUES
(
'" + objBasicBo.Employee_Id + @"'
,@EMP_Image
)
";
_dbconnection.Connect_ImageDB();
_dbconnection.AddParameter("@EMP_Image", SqlDbType.Binary, objadditionalbo.ImgByte);
this._dbconnection.ExecuteNonQuery(queryString);
this._dbconnection.CloseDatabase();
}
catch (Exception ex)
{
throw ex;
}
finally
{
this._dbconnection.CloseDatabase();
}
}
