public void DeleteEmployees(List <string> panList)
{
SqlCommand cmd = new SqlCommand("dbo.CoreEmployee_DeleteByPan");
cmd.Parameters.AddWithValue("@Pan", string.Join(",", panList));
_sqlDatabase.ExecuteNonSelect(cmd);
}
public void UpdateApiLogWithResponseAndTime(long apiLogId, string response, long timeInMs)
{
SqlCommand cmd = new SqlCommand("dbo.CoreApiLog_Update");
cmd.Parameters.AddWithValue("@ApiLogId", apiLogId);
cmd.Parameters.AddWithValue("@Response", response);
cmd.Parameters.AddWithValue("@TimeInMs", timeInMs);
_sqlDb.ExecuteNonSelect(cmd);
}