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