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(); } }