public void UpdateEmployeeEmergencyInfo(EmployeeEmergencyBO bo, int id)
{
string query = @"UPDATE [SBP_Employee_Emergency]
SET [Employee_ID] = " + bo.Employee_Emr_ID + ""
+ ",[Blood_Group] ='" + bo.Employee_Emr_Blood_Group.ToUpper() + "'"
+ ",[Emergency_Contact_Person] ='" + bo.Employee_Emr_Contact_Person + "'"
+ ",[RelationShip] ='" + bo.Employee_Emr_Relationship + "'"
+ ",[Contact_Number] ='" + bo.Employee_Emr_Contact_Number + "'"
+ ",[Contact_Address] ='" + bo.Employee_Emr_Contact_Address + "'"
+ ",[Insurance_Details] ='" + bo.Employee_Emr_Insurance_Details + "'"
+ ",[Special_Instruction] ='" + bo.Employee_Emr_Special_Instruction + "'"
+ ",[Remarks] ='" + bo.Employee_Emr_Remarks + "'"
+ ",[Update_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;
}
}
public void SaveEmpEmrInfo(EmployeeEmergencyBO EmrBo)
{
string query = @"INSERT INTO [SBP_Employee_Emergency]
([Employee_ID]
,[Blood_Group]
,[Emergency_Contact_Person]
,[RelationShip]
,[Contact_Number]
,[Contact_Address]
,[Insurance_Details]
,[Special_Instruction]
,[Remarks]
,[Update_Date]
,[Entry_By])
VALUES (" + EmrBo.Employee_Emr_ID + ",'"
+ EmrBo.Employee_Emr_Blood_Group.ToUpper() + "','"
+ EmrBo.Employee_Emr_Contact_Person + "','"
+ EmrBo.Employee_Emr_Relationship + "','"
+ EmrBo.Employee_Emr_Contact_Number + "','"
+ EmrBo.Employee_Emr_Contact_Address + "','"
+ EmrBo.Employee_Emr_Insurance_Details + "','"
+ EmrBo.Employee_Emr_Special_Instruction + "','"
+ EmrBo.Employee_Emr_Remarks + "',convert(varchar(11),getdate()),0)";
try
{
this.dbconnection.ConnectDatabase();
this.dbconnection.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
this.dbconnection.CloseDatabase();
}
}
