public void UpdateBranchMapping(EmployeeBranchMapBO braBo, int Id) { string query = @"UPDATE [SBP_Employee_Branch_Mapping] SET [Employee_ID] = " + braBo.Branch_Map_Employee_ID + "" + ",[Broker_Branch_ID] ='" + braBo.Branch_Map_Employee_Brach_ID + "'" + ",[Effective_From_Date] ='" + braBo.Branch_Map_Employee_From_Date.ToString("yyyy-MM-dd") + "'" + ",[Effective_To_Date] ='" + braBo.Branch_Map_Employee_To_Date.ToString("yyyy-MM-dd") + "'" + ",[Workstation_ID] ='" + braBo.Branch_Map_Employee_WorkStation_ID + "'" + ",[Update_Date] = 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 SaveBranchMaping(EmployeeBranchMapBO mapBo) { string query = @"INSERT INTO [SBP_Employee_Branch_Mapping] ([Employee_ID] ,[Broker_Branch_ID] ,[Effective_From_Date] ,[Effective_To_Date] ,[Workstation_ID] ,[Update_Date] ,[Entry_By]) VALUES (" + mapBo.Branch_Map_Employee_ID + ",'" + mapBo.Branch_Map_Employee_Brach_ID + "','" + mapBo.Branch_Map_Employee_From_Date.ToString("yyyy-MM-dd") + "','" + mapBo.Branch_Map_Employee_To_Date.ToString("yyyy-MM-dd") + "','" + mapBo.Branch_Map_Employee_WorkStation_ID + "',getdate(),0)"; try { this.dbconnection.ConnectDatabase(); this.dbconnection.ExecuteNonQuery(query); } catch (Exception ex) { throw ex; } }