public void UpdatEEmployeeReferenceInfo(EmployeeReferenceInfoBO UpEmpBo, int Id)
{
string query = @"UPDATE [SBP_Employee_Reference]
SET
[Reference_Name] = '" + UpEmpBo.Ref_Employee_Name + "'"
+ ",[Reference_Profession] = '" + UpEmpBo.Ref_Employee_Profession + "'"
+ ",[Reference_Phone] = '" + UpEmpBo.Ref_Employee_Phone + "'"
+ ",[Reference_Email] = '" + UpEmpBo.Ref_Employee_Email + "'"
+ ",[Reference_Address] = '" + UpEmpBo.Ref_Employee_Address + "'"
+ ",[Updated_Date] = convert(varchar(11),getdate())"
+ ",[Entry_By] = 0" + " WHERE Employee_Id=" + Id + "";
try
{
this._dbconnection.ConnectDatabase();
this._dbconnection.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
this._dbconnection.CloseDatabase();
}
}
public void SaveEmployeeReferenceInfo(EmployeeReferenceInfoBO objbo)
{
string query = @"INSERT INTO [SBP_Employee_Reference]
([Employee_ID]
,[Reference_Name]
,[Reference_Profession]
,[Reference_Phone]
,[Reference_Email]
,[Reference_Address]
,[Updated_Date]
,[Entry_By])
VALUES (" + objbo.Ref_Employee_ID + ",'"
+ objbo.Ref_Employee_Name + "','"
+ objbo.Ref_Employee_Profession + "','"
+ objbo.Ref_Employee_Phone + "','"
+ objbo.Ref_Employee_Email + "','"
+ objbo.Ref_Employee_Address + "',convert(varchar(11),getdate(),106),0)";
try
{
this._dbconnection.ConnectDatabase();
this._dbconnection.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
this._dbconnection.CloseDatabase();
}
}